subject
Business, 22.05.2020 06:59 huntbuck14

Nike Corp. supplies its four retail outlets from its four plants. The shipping cost per shipment from each plant to each retail outlet is given below. Unit Shipping Cost Retail Outlet Plant 1 2 3 4 1 $700 $800 $500 $200 2 $200 $900 $100 $400 3 $400 $500 $300 $100 4 $200 $100 $400 $300 Plants 1, 2, 3 and 4 make 10, 20, 20, and 10 shipments per month, respectively. Retail outlets 1, 2, 3, and 4 need to receive 20, 10, 10, and 20 shipment per month, respectively. The distribution manager now wants to determine the best plan for how many shipments to send from each plant to the respective retail outlets each month. The manager’s objective is to minimize the total shipping cost

a. formulate this problem on a spreadsheet and use Solver to find an optimal solution.

ansver
Answers: 1

Another question on Business

question
Business, 22.06.2019 03:30
Lo.2, 3, 9 lori, who is single, purchased 5-years class property for $200,00 and 7-years class property for $420,000 on may 20, 2018. lori experts the taxable income derived form the business (without regard to the amount expensed under ⧠179) to be about $550,000. lori has determined that she should elect immediate ⧠179 expensing in the amount of $520,000, but she doesn’t know which asset she should completely expense under ⧠179. she does not claim any available additional first-year depreciation. a. determine lori’s total cost recovery deduction if the ⧠179 expense is first taken with respect to the 5-year class asset. b. determine lori’s total cost recovery deduction if the ⧠179 expense is first taken with respect to the 7-year class asset. c. what is your advice for lori? d. assume that lori is in the 24% marginal tax bracket and that she uses ⧠179 on the 7-year asset. determine the present value of the tax savings from the depreciation deductions for both assets. see appendix g for present value factors, and assume a 6% discount rate. e. assume the same facts as in part (d), except that lori decides not to use ⧠179 on either asset. determine the present value of the tax savings under this choice. in addition, determine which option lori should choose. f. present your solution to parts (d) and (e) of the problem in a spreadsheet using appropriate microsoft excel formulas. e-mail your spreadsheet to your instructor with a two-paragraph summary of your findings.
Answers: 1
question
Business, 22.06.2019 11:00
The role of the credit department includes: a. evaluating customers' credit applications to determine whether they meet the company's approval standards. b. approving all credit applications in order to avoid losing sales. c. collecting cash from customers. d. following unwritten approval standards for processing customers' credit applications.
Answers: 2
question
Business, 22.06.2019 21:00
Noah met an old friend at a coffee shop. he jotted down the friend's new phone number, but later that afternoon he could not find it or remember what he had done with it. a couple of days later, noah went back to the coffee shop, and while waiting in line, he suddenly remembered where he had put the phone number. this is an example of:
Answers: 1
question
Business, 22.06.2019 22:10
Which of the following tends to result in a decrease in the selling price of houses in an area? a. an increase in the population of the city or town. b. an increase in the labor costs of construction. c. an increase in the income of new residents in the city or town. d. an increase in mortgage interest rates.
Answers: 1
You know the right answer?
Nike Corp. supplies its four retail outlets from its four plants. The shipping cost per shipment fro...
Questions
question
Chemistry, 25.06.2019 22:00
question
History, 25.06.2019 22:00
Questions on the website: 13722360