Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 1 Based on the parameter values and forecast shown below, prepare two aggregate plans using Excel. One plan should use a chase strategy, and

image text in transcribedimage text in transcribedimage text in transcribed

QUESTION 1 Based on the parameter values and forecast shown below, prepare two aggregate plans using Excel. One plan should use a chase strategy, and the other plan should use a level strategy. Assume that the planned production prior to month 1 is the same as the planned production in month 1. (This means that you will not hire or fire any workers or incur hiring or firing costs in the first month.) Include the following in each plan: Planned production for each month Ending inventory for each month Inventory holding cost for each month Workforce level (number of workers) for each month Production cost for each month Hiring cost for each month Firing cost for each month Total holding cost for the plan Total hiring cost for the plan Total firing cost for the plan Total production cost for the plan Total cost for the plan, including holding, hiring, firing, and production costs Labor standard (hours/unit) Number of hours per worker per month Hiring cost per unit Firing cost per unit Inventory holding cost per unit per month Production cost per unit Beginning inventory (ending inventory prior to month 1) Ending inventory in month 12 8 4 160 5 6 2 15 0 0 Month Forecast 1 4000 2 1000 3 2000 4 2000 5 4000 6 5000 7 6000 8 6000 9 5000 10 4000 11 2000 12 7000 QUESTION 18 For the LEVEL STRATEGY, what is the workforce level (number of workers) in month 8? Enter a whole number. QUESTION 19 For the LEVEL STRATEGY, what is the production cost in month 8? Enter a whole number without a dollar sign. QUESTION 20 For the LEVEL STRATEGY, what is the hiring cost in month 8? Enter a whole number without a dollar sign. QUESTION 21 For the LEVEL STRATEGY, what is the firing cost in month 8? Enter a whole number without a dollar sign

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

Recommended Textbook for

A Guide To Local Environmental Auditing

Authors: Hugh Barton; Noel Bruder

1st Edition

1853832340, 9781853832345

More Books

Students also viewed these Accounting questions