help:) thank you!! two parts b. Compare the costs to a level plan that uses inventory to absorb fluctuations. Inventory carrying cost is $3 per engine per month.Backlog cost is $135 per engine per month. There should not be a backlog in the last month. Set regular production equal to themonthly average of total forecasted demand. Assume that using overtime is not an option. (Negative amounts should be indicated bya minus sign. Leave no cells blank-be certain to enter "0" wherever required. Round average inventory row, Inventory cost row,and Total row values to 1 decimal.)PeriodForecastOutputRegularOutput-ForecastInventoryBeginningEndingAverageBacklogCostsOutputRegularInventoryBackorderTotal902951001051151281348145Total912 DSProblem 11-5 (Algo)Manager T. C. Downs of Plum Engines, a producer of lawn mowers and leaf blowers, must develop an aggregate plan given theforecast for engine demand shown in the table. The department has a regular output capacity of 140 engines per month. Regularoutput has a cost of $65 per engine. The beginning inventory is zero engines. Overtime has a cost of $115 per engine.ForecastForecastOutputRegularOvertimeOutput-ForecastCostsOutputRegularOvertime90Total295310090a. Develop a chase plan that matches the forecast and compute the total cost of your plan. Regular production can be less thanregular capacity. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" whereverrequired.)Period2Month95410551151006128105713458145115Total91212871348145Total912Check my

Aggregate planning is a high-level planning activity that focuses on determining the best…

b. Compare the costs to a level plan that uses inventory to absorb fluctuations. Inventory carrying cost is $3 per engine per month. Backlog cost is $135 per engine per month. There should not be a backlog in the last month. Set regular production equal to the monthly average of total forecasted demand. Assume that using overtime is not an option. (Negative amounts should be indicated be a minus sign. Leave no cells blank-be certain to enter "0" wherever required. Round average inventory row, Inventory cost row, and Total row values to 1 decimal.) Period Forecast Output Regular Output-Forecast Inventory Beginning Ending Average Backlog Costs Output Regular Inventory Backorder Total 90 95 100 105 115 128 134 145 Total 912

b. Compare the costs to a level plan that uses inventory to absorb fluctuations. Inventory carrying cost is $3 per engine per month. Backlog cost is $135 per engine per month. There should not be a backlog in the last month. Set regular production equal to the monthly average of total forecasted demand. Assume that using overtime is not an option. (Negative amounts should be indicated be a minus sign. Leave no cells blank-be certain to enter "0" wherever required. Round average inventory row, Inventory cost row, and Total row values to 1 decimal.) Period Forecast Output Regular Output-Forecast Inventory Beginning Ending Average Backlog Costs Output Regular Inventory Backorder Total 90 95 100 105 115 128 134 145 Total 912

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

3.) Compile a hypothetical list of stakeholders’ needs. Stakeholder Wants (“Whats”) System Attributes (“Hows”)
QUESTION 4 a. Explain any two process technologies for materials.b. Discuss any three factors that will help to determine the type of production process used.c. Distinguish between design capacity and effective capacity. Provide a brief example.d. Why is the capacity decision important?e. A regional bank training center has the physical ability to handle 1,300 participants. However, management personnel believe that only 1,100 participants can be handled effectively for most training sessions. The last training session, although forecasted to have 1,000 participants, resulted in the attendance of only 990 participants. Calculate the utilization and efficiency of the training facility.
QUESTION 2 With quantity competition, horizontal mergers might be socially efficient but not profitable for the firms. O True O False
2. Which of the following is a sunk cost? A. Insurance on new machine B. Salvage value of old machine C. Purchase price of new machine D. Purchase price of old machine
Q) Height, Weight, Length are the example of which scale?
The self-directed work team is composed of individuals who areassigned a cluster of tasks, duties and responsibilities to be accomplished.Question 10 options: True False
Components of an integrated manufacturing system include: Question 17 options: a. material handling equipment b. computer control c. human workers d. all of the above
Name 5 departmental grouping options
QUESTION: How to perform simple calculations involving supply ordering, inventory control and budget control? Reminder for the expert: Please include the source of the informations (references) by APA format. This is related to Laboratory Management Subject.
How to communicate requirement for a project
Question 19 Dana Pastries developed a five-year plan to comply with a new industry standard. Each year's goals are set with gradual, incremental organizational changes focusing on one area of the new standard. Specify ( L) and deflne (: ) the type of change that Is Implemented In the case. Use the editor to format your answer
Question 9