Question

In: Accounting

firm need to produce the following number of units during the next three months; month 1,...

firm need to produce the following number of units during the next three months; month 1, 200 units; month 2, 300 units; month 3, 300 units. For each unit produced during months 1 and 2, a $9 variable cost is incurred; for each unit produced during month 3, a $12 variable cost is incurred. The inventory cost is $2.50 for each unit in stock at the end of a month. The cost of setting up for production during a month is $250. Units made during a month may be used to meet demand for that month or next month only. Assume that production during each month must be a multiple of 100. Given that the initial inventory level is 0 units, use dynamic programming to determine an optimal production schedule

Solutions

Expert Solution

Given Information

Opening Inventory=0 units

Set up cost for Every Month= $250

Inventory Holding Cost =$2.5 per Unit

Variable cost per unit

Production(Units)

Month 1

$9

200

Month 2

$9

300

Month 3

$12

300

Case 1

Given

Set up cost for every month =$250

In this Case we just produce the required demand in their corresponding months.

Month 1

Month 2

Month 3

Demand

200

300

300

Production

200

300

300

Cost

250 + 200*$9

=$2050/-

250 + 300*$9

=$2950/-

250 + 300*$12

=$3850/-

Total cost = $2050+$2950+$3850 =$8850/-

Case 2:

Inventory Holding Cost =$2.5 per Unit

In this case as the production cost is $3 less in Month 2 we produce the demand of Month 3 in Month 2 itself.

Month 1

Month 2

Month 3

Demand

200

300

300

Production

200

300+300 =600

0

Cost

250 + 200*9

=$2050/-

250 + 600*9+2.5*300

=$6400/-

0

Total cost = $2050+$6400=$8450/-

Conclusion:

We can see that Production cost in Case 2 is less than Case 1.

Hence the optimal production schedule is Case 2

PLEASE LIKE THIS ANSWER, IT HELPS ME A LOT. THANK YOU


Related Solutions

A firm need to produce the following number of units during the next three months; month...
A firm need to produce the following number of units during the next three months; month 1, 200 units; month 2, 300 units; month 3, 300 units. For each unit produced during months 1 and 2, a $9 variable cost is incurred; for each unit produced during month 3, a $12 variable cost is incurred. The inventory cost is $2.50 for each unit in stock at the end of a month. The cost of setting up for production during a...
Workco must have the following number of workers available during the next three months: month 1,...
Workco must have the following number of workers available during the next three months: month 1, 20; month 2, 16; month 3, 25. At the beginning of month 1, Workco has no workers. It costs Workco $100 to hire a worker and $50 to fire a worker. Each worker is paid a salary of $140/month. Formulate the problem of determining a hiring and firing strategy that minimizes the total cost incurred during the next three months as a MCNF problem.
Croy Inc. has the following projected sales for the next five months: Month Sales in Units...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,470 May 3,890 June 4,520 July 4,170 August 3,980 Croy’s finished goods inventory policy is to have 70 percent of the next month’s sales on hand at the end of each month. Direct material costs $3.00 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at the...
Croy Inc. has the following projected sales for the next five months:    Month Sales in Units...
Croy Inc. has the following projected sales for the next five months:    Month Sales in Units April 3,500 May 3,945 June 4,640 July 4,110 August 3,920 Croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. Direct material costs $3.40 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at the...
Croy Inc. has the following projected sales for the next five months:    Month Sales in Units...
Croy Inc. has the following projected sales for the next five months:    Month Sales in Units April 3,410 May 3,885 June 4,590 July 4,175 August 3,900 Croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. Direct material costs $2.90 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at the...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,410 May 3,895 June 4,520 July 4,105 August 3,970 Croy’s finished goods inventory policy is to have 50 percent of the next month’s sales on hand at the end of each month. Direct materials costs $2.60 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,520 May 3,840 June 4,630 July 4,190 August 3,940 Croy’s finished goods inventory policy is to have 50 percent of the next month’s sales on hand at the end of each month. Direct materials costs $3.00 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,560 May 3,810 June 4,550 July 4,110 August 3,990 Croy’s finished goods inventory policy is to have 70 percent of the next month’s sales on hand at the end of each month. Direct material costs $3.50 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at the...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,500 May 3,870 June 4,630 July 4,115 August 4,000 Croy’s finished goods inventory policy is to have 50 percent of the next month’s sales on hand at the end of each month. Direct materials costs $3.20 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,430 May 3,900 June 4,530 July 4,115 August 4,000 Croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. Direct material costs $2.80 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT