I've attached an excel file please slove it in the excel file with screenshots of the formulas. So I can understand how to solve the problem step by step. thank you 

A company faces the following demands during the next three weeks: week 1, 2000 units; week 2, 1000 units; week 3, 1500 units. The unit production costs during each week are as follows: week 1, $130; week 2, $140; week 3, $150. A holding cost of $20 per unit is assessed against each week’s ending inventory. At the beginning of week 1, the company has 500 units on hand. In reality, not all goods produced during a month can be used to meet the current month’s demand. To model this fact, assume that only half of the goods produced during a week can be used to meet the current week’s demands.

a. Determine how to minimize the cost of meeting the demand for the next three weeks.

b. Revise the model so that the demands are of the form Dt + kCt, where Dt is the original demand (from above) in month t, k is a given factor, and Ct is an amount of change in month t demand. Develop the model in such a way that you can use Solver Table to analyze changes in the amounts produced and the total cost when k varies from 0 to 10 in 1-unit increments, for any fixed values of the Cs. For example, try this when C1 = 200, C2 = 500, and C3 = 300. Describe the behavior you observe in the table. Can you find any reasonable Cs that induce positive production levels in week 3?

 

 

Problem 29 Chapter 3 Page 123
Input Data
Beginning Inventory
Demands, Unit production costs and holding costs
Week 1 Week 2 Week 3 Week 1 Week 2 Week 3 Demand
Unit Production Costs
Unit Holding Costs
Production Plan
Units Produced
Units Available to meet demand
Demand
Ending Inventory
Summary of Costs
Production Costs
Holding Costs
Total Cost

• 1493801830-Solutions file 2.docx

ComputerScienceExpert

(11)

Status NEW Posted 03 May 2017 08:05 AM My Price 8.00

-----------

Attachments

file 1493801826-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer