A company produces a niche hunting blind. Because of the nature of this product, demand varles...

 

Transcribed Image Text:

A company produces a niche hunting blind. Because of the nature of this product, demand varles greatly by season. In fact, demand exceeds production capacity during hunting season (fall) but is very low in the summer months. To meet the high demand during the fall, the company produces the blind year round, producing more than what is needed in the summer in order to carry over Inventory into the peak season. Their production facility can produce at most 60 blinds per month using regular labor at a cost of$125 each. Up to 15 additional blinds can be produced by utillzing overtime labor at a cost of $135 each. The blinds are sold for $225, Because of storage cost and the opportunity cost of capital, each blind held in inventory from one month to the next incurs a cost of $15 per bilind, Since demand is uncertain. the company would like to maintain an ending inventory of at least 5 blinds during the warm months (May-September) and at least 15 blinds during the other months (October-April). It is now the start of January and the company has S bilinds in Inventory. The forecast of demand over the next 12 months is shown in the folowing table. Formulate and solve a linear programming model in a spreadsheet to determine how many bilinds should be produced each month to maximlze total profit. Jan. Feb. Mar. Apr. May June July Aug. Sept. Oct. Nov. Dec. 65 30 25 30 45 10 25 40 95 90 90 Remember, • Correct answers with no formulasholver input will not recelve full credit. When grading spreadsheets, I look at. • Formulas O Solver Inputs • Formatting O Numerical answers A company produces a niche hunting blind. Because of the nature of this product, demand varles greatly by season. In fact, demand exceeds production capacity during hunting season (fall) but is very low in the summer months. To meet the high demand during the fall, the company produces the blind year round, producing more than what is needed in the summer in order to carry over Inventory into the peak season. Their production facility can produce at most 60 blinds per month using regular labor at a cost of$125 each. Up to 15 additional blinds can be produced by utillzing overtime labor at a cost of $135 each. The blinds are sold for $225, Because of storage cost and the opportunity cost of capital, each blind held in inventory from one month to the next incurs a cost of $15 per bilind, Since demand is uncertain. the company would like to maintain an ending inventory of at least 5 blinds during the warm months (May-September) and at least 15 blinds during the other months (October-April). It is now the start of January and the company has S bilinds in Inventory. The forecast of demand over the next 12 months is shown in the folowing table. Formulate and solve a linear programming model in a spreadsheet to determine how many bilinds should be produced each month to maximlze total profit. Jan. Feb. Mar. Apr. May June July Aug. Sept. Oct. Nov. Dec. 65 30 25 30 45 10 25 40 95 90 90 Remember, • Correct answers with no formulasholver input will not recelve full credit. When grading spreadsheets, I look at. • Formulas O Solver Inputs • Formatting O Numerical answers

Answer rating: 100% (QA)

Given details Find the Given details Given details Month Jan Feb ... View the full answer