Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A small company produces soda drinks. The salesperson has developed the following aggregate forecast for demand in cases) for the next four quarters. Quarter 1

image text in transcribed
A small company produces soda drinks. The salesperson has developed the following aggregate forecast for demand in cases) for the next four quarters. Quarter 1 2 3 4 Demand Forecast 4,000 4,800 7,900 5,100 # of Working Days 62 58 62 58 Material Cost $10 per case Inventory Holding cost $2/case/quarter Marginal cost of stockout $5/case/quarter Hiring and training cost $300/worker Layoff cost $500/worker Labor hours required 4 hours/case Shift 8 hours/day Regular time cost $7/hour Overtime cost $9/hour Subcontracting cost $30 per case Beginning workforce 40 workers Develop aggregate production plans using the following strategies. State which approach should be preferred based on cost. Please use the whole numbers for this question (eg., 1.5 and above = 2 and 1.49 and less = 1). A) Produce to meet expected average demand over the next four quarters by maintaining a stable workforce of 42 workers. Manage the demand variations only by using backorders or carrying inventory. Assume a beginning inventory of 1,000 cases at the start of the planning horizon, but that there is no requirement for any specified number of cases in the ending inventory in any period of the plan. B) Suppose on the other hand, that we only want to use a constant workforce of 35 workers. Devise a plan that uses regular time and overtime production combined with outsourcing Inventory and backorders are not allowed except for a beginning inventory of 1000 cases at the start of the planning horizon and a planned ending inventory of 500 cases in quarter 4. Each worker is allowed a maximum of 2 hours of overtime per day. You must apply all available overtime hours before outsourcing any production A small company produces soda drinks. The salesperson has developed the following aggregate forecast for demand in cases) for the next four quarters. Quarter 1 2 3 4 Demand Forecast 4,000 4,800 7,900 5,100 # of Working Days 62 58 62 58 Material Cost $10 per case Inventory Holding cost $2/case/quarter Marginal cost of stockout $5/case/quarter Hiring and training cost $300/worker Layoff cost $500/worker Labor hours required 4 hours/case Shift 8 hours/day Regular time cost $7/hour Overtime cost $9/hour Subcontracting cost $30 per case Beginning workforce 40 workers Develop aggregate production plans using the following strategies. State which approach should be preferred based on cost. Please use the whole numbers for this question (eg., 1.5 and above = 2 and 1.49 and less = 1). A) Produce to meet expected average demand over the next four quarters by maintaining a stable workforce of 42 workers. Manage the demand variations only by using backorders or carrying inventory. Assume a beginning inventory of 1,000 cases at the start of the planning horizon, but that there is no requirement for any specified number of cases in the ending inventory in any period of the plan. B) Suppose on the other hand, that we only want to use a constant workforce of 35 workers. Devise a plan that uses regular time and overtime production combined with outsourcing Inventory and backorders are not allowed except for a beginning inventory of 1000 cases at the start of the planning horizon and a planned ending inventory of 500 cases in quarter 4. Each worker is allowed a maximum of 2 hours of overtime per day. You must apply all available overtime hours before outsourcing any production

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions