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 2 With quantity competition, horizontal mergers might be socially efficient but not profitable for the firms. O True O False
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
How to communicate requirement for a project
Question 9
Question 1
q. 10 Refer to the Load Balance Diagram. Which of the following is true about with respect to precedence? Group of answer choices a. A and C have no precedence b. A precedes B, C, D and E c. E precedes A, B, C and D d. Exact precedence is impossible to determine from this diagram
Question 16 MONTH EXPECTED DEMAND PRODUCTION DAYS Jan 800 21 Feb 500 18 Mar 600 18 Apr 1050 22 May 1150 19 June 1100 20 Cost Information: Subcontracting cost = SR 17 per unit per month Average pay rate = SR 10 per hour Labor-hours to produce a unit = 4 hours per unit Daily working hours = 8 hours a) Using excel, caleulate the total cost of the following plan : - Plan : is to maintain a constant workforce at a level necessary to meet the lowest demand month and to meet all demand above this level by subcontracting. (Answer in Field ) Attach your solutions.
question 1 Terminator, Inc., manufactures a motorcycle part in lots of 250 units. The raw materials cost for the part is $150, and the value added in manufacturing 1 unit from its components is $280, for a total cost per completed unit of $430. The lead time to make the part is 3 weeks, and the annual demand is 4,200 units. Assume 50 working weeks per year. a. How many units of the part are held, on average, as cycle inventory? nothing units. (Enter your response as an integer.) What is its value? $_______.(Enter your response as an integer.) b. How many units of the part are held, on average, as pipeline inventory? nothing units. (Enter your response as an integer.) What is its value? $________________ (Enter your response as an integer.)
There are 3 processes that move materials to and from the firm. Question 6 options: True False
Time left 0:35:31 Question 4 Answer saved Marked out of 1.00 Flag question Question text The Campbell Company is evaluating the proposed acquisition of a new milling machine. The machine’s base price is $108,000, and it would cost another $12, 500 to modify it for special use by your firm. The machine will be sold after three years for $65,000. The applicable depreciation rates are 33 percent, 45 percent, 15 percent, and 7 percent. The machine would require an increase in net operating working capital (inventory) of $5,500. The machine would have no effect on revenues, but is expected to save the firm $44,000 per year in before tax operating costs, mainly labor. Campbell’s marginal tax rate is 35 percent. What is the Net Investment (NINV)