Get help from the best in academic writing.

# University of North Carolina Wilmington Simple Linear Programming Excel Task

University of North Carolina Wilmington Simple Linear Programming Excel Task.

I need the same thing as last week. 2 Homework questions answered using Solver in excel.1. Lincoln Lock Company The Lincoln Lock Company manufactures a commercial security
lock at plants in Atlanta, Louisville, Detroit, and Phoenix. The unit cost of production at each
plant is \$35.50, \$37.50, \$37.25, and \$36.25, and the annual capacities are 18,000, 15,000, 18,000,
and 20,000, respectively. The locks are sold through wholesale distributors in seven locations
around the country. The unit shipping cost for each plant– distributor combination is shown in the
following table, along with the forecasted demand from each distributor for the coming year. Set
this problem as a network flow model and determine the least costly way of shipping locks from
plants to distributors. plants to distributors.
Tacoma SanDiego Dallas Denver StLouis Tampa Baltimore
Atlanta 2.50 2.75 1.75 2.00 2.10 1.80 1.65
Louisville 1.85 1.90 1.50 1.60 1.00 1.90 1.85
From: Plants Detroit 2.30 2.25 1.85 1.25 1.50 2.25 2.00
Phoenix 1.90 0.90 1.60 1.75 2.00 2.50 2.65
Demand 5500 11500 10500 9600 15400 12500 66002. Assigning Tasks Suppose a data processing department wishes to assign five programmers
to five programming tasks (one programmer to each task). Management has estimated the total
number of days each programmer would take if assigned to the different jobs, and these estimates
are summarized in the following table.
Task 1 2 3 4 5
1 50 25 78 64 60
2 43 30 70 56 72
Programmer 3 60 28 80 66 68
4 54 29 75 60 70
5 45 32 70 62 75
1. Determine the assignment that minimizes the total programmer days required to complete
all five jobs.
University of North Carolina Wilmington Simple Linear Programming Excel Task

## Extent of competition in the banking industry

Corporate services — fixed cost Hourly personnel is a variable cost because the cost is dependent upon how many revenue hours are worked by the staff. If they sell for 0 hours, there is still a rent expense. Power is a variable cost because the cost is directly related to the number of hours computers were used in operation. The more hours used, the higher the cost of power. Rent is a fixed cost because it must be paid no matter how many hours the company is operating. Rent must be paid whether the company is selling or not. Custodial services is a fixed cost because it is based on Salem Telephone’s estimated annual cost per square foot. It is not dependent on the amount of revenue hours. Computer leases is a fixed cost because it is independent of revenue hours. This cost will stay the same regardless of the amount of revenue hours. Maintenance is a fixed cost because it is not dependent on the number of revenue hours. Depreciation on computer equipment does not depend on the amount of revenue hours. Depreciation on office equipment is not dependent upon revenue hours. Salaried staff is paid a salary regardless of the amount of revenue hours. The amount the staff is paid is not affected by a change in revenue hours. System maintenance is not dependant on the hours of selling Administration salary is not related to the amount of revenue hours. Sales wages does not depend on the amount of revenue hours. Sales promotion does not vary with a change in revenue hours. Corporate services is a fixed cost because the amount is not dependent upon the number of revenue hours. For each expense that is variable with respect to revenue hours, calculate the cost per revenue hour. Power cost per revenue hour: January: \$1,546/329 hours = \$4.70 February: \$1,485/316 hours = \$4.70 March: \$1,679/361 hours = \$4.70 Operations: hourly personnel: January: \$7,896/329 hours = \$24.00 February: \$7,584/316 hours = \$24.00 March: \$8,664/361 hours = \$24.00 Variable costs in total change in direct proportion to changes in volume of activity but remains constant per unit when the volume of activity changes. Create a contribution margin income state for Salem Data Services. Assume that intracompany usage is 205 hours. Assume commercial usage is at the March level. **See Exhibit 1 Assuming the intracompany demand for service will average 205 hours per month, what level of commercial revenue hours of computer use would be necessary to break even each month? Break-even point = Fixed costs/ CM per unit Sales revenue per unit = \$82,000/205= \$400.00 Variable cost per unit = \$9,844.10/343= \$28.70 (205 x \$400 A x \$800) – 28.70 x (205 A) – 212,939 = 0 82,000 800A – 28.70A – 5883.50 – 212,939 = 0 -136,822.50 771.30A = 0 771.30 A = 136,882.50 A = 177.39 Salem Data Services would need 177.39 commercial hours to break even. Estimate the following effect on income of each of the options Floes has suggested if Wu estimates as follows: Increasing the price to commercial customers to \$1,000 per hour would reduce demand by 30%. Commercial revenue hours = 138 With a 30% decrease in demand, commercial revenue hours would be reduced to: 138 x 30% = 41.4 138 – 41.4 = 96.6 hours Revenue Intracompany sales (205x\$400) \$82,000 Commercial sales (96.6x\$1,000) 96,600 Less: VC (301.60×28.70) (8,655.92) CM 169,944.08 Less: FC (212,939) Net Income (\$42,994.92) This option would result in an additional loss of (\$12,611.92) leaving a total net loss of (\$42,994.92). Reducing the price to commercial customers to \$600 per hour would increase demand by 30% Commercial revenue hours = 138 With a 30% increase in demand, commercial revenue hours would increase to: 138 x 30% = 41.4 138 41.4 = 179.4 hours Revenue Intracompany sales (205x\$400) \$82,000 Commercial sales (179.4x\$600) 107,640 Less: VC (384.4x\$28.70) (11,032.28) CM 178,607.72 Less: FC (212,939) Net Income (\$34,331.28) This option would result in an additional loss of (\$3,948.28) resulting in a total net loss of (\$34,331.28). Increased promotion would increase revenue hours by up to 30%. Wu is unsure how much promotion this would take. (How much could be spent and still leave Salem Data Services with no reported loss each month if commercial hours were increased 30%?) Commercial revenue hours = 138 Commercial revenue hours with a 30% increase = 138 x 30% = 41.4 138 41.4 = 179.4 hours Revenue Intracompany sales (205x\$400) \$82,000 Commercial sales (179.4x\$800) 143,520 Less: VC (384.4x\$28.70) (11,032.28) CM 214,487.72 Less: FC (212,939) Net Income \$1,548.72 The maximum amount that could be spent and still leaves Salem Data Services with no reported loss each month if commercial hours were increased 30% would be \$1,548.72. Salem Data Services spent \$8,083 on sales promotion in March. Therefore, a total of \$9,631.72 (\$1,548.72 \$8,083) could be spent on sales promotion without incurring a net loss. Based on your analysis above, is Salem Data Services really a problem to Salem Telephone Company? What should Flores do about Salem Data Services? Based on our analysis above, we feel that Salem Telephone Company should keep Salem Data Services. Although Salem Data Services’ fixed costs are very high and profits have not been obtained in previous periods, Salem Telephone Company should maintain Salem Data Services. Exhibit 2 shows that the net loss from February to March decreased \$16,987. If Salem Telephone Company were to shut down Salem Data Services, the company would save a large amount of money in fixed costs but would have to spend money to make up for the intracompany revenue hours. Salem should keep Salem Data Services in operations, regardless of showing a net loss. If Data Services closed, Salem would incur the following additional costs: Purchase of intracompany hours (at market cost): 205 hours x \$800 = \$164,000 Fixed costs saved if SDS closed (March): Rent \$8,000 Custodial services \$1,240 Maintenance \$5,400 Power \$1,697 Operations: salaried staff \$21,600 Operations: hourly personnel \$8,664 Systems development \$12,000 Administration \$9,000 Sales \$11,200 Promotions \$8,083 Total savings \$86,884 (205 hours x \$800) \$164,000 – Purchase of intracompany hours (\$86,884) – Savings if Salem Data Services closed \$77,116 – Cost savings for operating Salem Data Services In this situation, the benefits outweigh the costs. Salem Telephone Company would be saving \$86,884 in costs but would have to purchase intracompany hours at \$164,000. Flores should continue to operate Salem Data Services; however, they should focus on methods to cut costs by re-evaluating its labor necessities and increasing awareness through promotion to increase long-term profitability. Another aspect for Flores to take into consideration is to re-evaluate and forecast commercial sales willingness to pay in order to increase its break-even potential. From the analysis in question five, Flores could reduce the price to commercial customers, thereby increasing demand. Using this strategy in addition to cutting costs will increase Salem Data Services profitability.

## journal

i need help writing an essay -What, if anything, makes you nervous about this class? -What do you know/understand about race in our current world? -How do you understand your race and racial identity? -What are some questions that you have about race and racism? -Do you have any questions about this class? -Is there anything in particular that you want me to know as we begin to start this class? You do not have to answer all of these questions, I just ask that you keep some of them in mind as you write. Please remember that you are being asked to write 2-3 pages minimum, but you are welcome to write more if you feel inclined to do so.

## Academy College Razor Scooter Sales Contract Descriptive Essay

Academy College Razor Scooter Sales Contract Descriptive Essay.

The contract you will be using is in the Contracts Module.You will be given a contract with questions to be answered for the contract. I am looking for the ability to read and comprehend the contract so the appropriate contract clause can be applied to the questions connected with the contract. In order to answer the contract fact scenario, you will also need to be able to identify the legal concept that is applicable to the situation described. This is an analysis so please treat it as such. Your personal opinion is not appropriate.There are correct answers for each question. If a student discusses a different legal theory for answering the questions, partial points will be given. In cases of complete or partial answers, readings references are mandatory to support the remedy proposed by the student. A reading reference that has no bearing on the remedy or legal arguments will be counted as “no reference”. For example, if any contract has an issue of risk of loss, referencing the text on contract formation will not meet the requirement.Please remember to reference the applicable parts of the contract that you are using to answer each question.This analysis is worth 21 points. Within each question, a student will be given 2 points for the text reference, 3 points for the contract reference, with 8 points for the analysis. Please remember, NO outside references. That will be an automatic point deduction and will not be considered a text reference.The remaining 2 points will be given as an a spelling/grammar score. Following are the prompts.UCC Sales ContractThe following question is based on the Sales Contract found in the Contracts Module. Please reference the Sales Contract by clause number as you answer the questions. Remember, this is a contract under the UCC.
Essay (2 complete paragraphs minimum per essay with text and contract references to support your answers)
You, the buyer, contend that you received non-conforming goods as a result of an ambiguity in the contract. You ordered goods thinking you would get a particular product. You wanted Razor scooters. That was the original oral communication when you first contacted the selling merchant. You both talked about and agreed on Razor scooters. Thereafter, in phone conversations, you and the seller just used the phrase scooters. The seller prepared a written contract. The contract was signed by both parties. The selling merchant then shipped scooters that are in perfect condition but they are not Razor scooters. The selling merchant believes the goods are conforming. Upon receipt and inspection of the goods, what are all your merchant options under the contract and at law?* (Why are text references important? Contract language does not exist in a vacuum. It is written based on the law. It is critical, therefore, to cite to the readings and the contract to support your analysis.) Do not use other references instead of the assigned readings. Remember, I also do plagiarism checks.
Academy College Razor Scooter Sales Contract Descriptive Essay

### Essay Writing at Online Custom Essay

5.0 rating based on 10,001 ratings

Rated 4.9/5
10001 review

Review This Service

Rating: