PP.52 A manufacturer of solid state drives (SSDs) has projected the next six months of demand to be as shown the table below:Supply/Demand InfoFebMarJun49,00051,20049,000Forecast (demand)Regular productionOvertime productionSubcontract productionEnding inventoryHired employeesFired employeesTotal employeesCost variables are as follows:Cost VariablesLabor cost/hourOvertime cost/unitSubcontracting cost/unitHolding cost/unit/monthHiring cost/employeeFiring cost/employeeBeginning Jan45,0007,200160$19$34$31$11$3,700$5,800Here is some additional relevant (capacity) information:Capacity InformationTotal labor hours/SSDRegular production units/employee/monthMax regular production/monthMax overtime production/monthMax subcontractor production/month320056,6003,0004,200Apr May62,60045,600 Assuming the company uses regular production first, then ONLY overtime and/or subcontract production, answer the following questions:What is the regular production cost (over the six months from January through June) for a CHASE production plan? (Display your answer to the nearestwhole number.)NumberWhat is the total overtime production cost for this production plan? (Display your answer to the nearest whole number.)NumberWhat is the total subcontract cost for this production plan? (Display your answer to the nearest whole number.)NumberWhat is the total holding cost for this production plan? (Display your answer to the nearest whole number.)NumberWhat is the total hire cost for this production plan? (Display your answer to the nearest whole number.)NumberWhat is the total fire cost for this production plan? (Display your answer to the nearest whole number.)NumberWhat is the total cost (sum of all costs) for this production plan? (Display your answer to the nearest whole number.)Number

Chase plan means producing only as much required i.e. keeping the inventory to minimum levels i.e.…

Answered: PP.52 A manufacturer of solid state…

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

The consulting agency begins collecting data on actual population demand utilization. The first year s data is: Period March 2020 April 2020 May 2020 June 2020 Demand 31,550 40,125 38,243 35,311 32,207 32,125 35,700 40,620 n Period Demand September 41,482 2020 October 2020 November 2020 December 2020 January 2021 38,450 February 2021 33,330 38,348 34,722 36,190 July 2020 42,810 August 2020 44,230 What is the forecast demand for March 2021 considering trend and seasonality?
7. Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next six months. Month May Jun Jul Forecast 4,000 4,800 5,600 Aug Sep 7,200 Oct 6,400 5,000 Use the following information to develop aggregate plans. Regular production cost Regular production capacity Overtime production cost Subcontracting cost Holding cost Beginning inventory $10 per case 5,000 cases $16 per case $20 per case $1 per case per month 0 Develop an aggregate plan using each of the following guidelines and compute the total cost for each plan. Which plan has the lowest total cost? a. Use level production. Supplement using overtime as needed. b. Use a combination of overtime (500 cases per period maximum), inventory, and subcontracting (500 cases per period maximum) to handle variations in demand. c. Use overtime up to 750 cases per period and inventory to handle variations in demand.
QUESTIONS (Using the same problem) A vendor for the local ballpark food stand is questioning whether to stock his concession with a large or small inventory. He believes that it will depend upon the size of the crowd. He has developed a payoff matrix for the various alternatives (stocking decision) and states of nature (size of crowd). What is the Expected Monetary Value (EMV)? Alternatives Large Inventory Small Inventory Probability OA) $68,400 O B)-$20,000 O C) $10,000 O D) $51,500 O E) $78,400 Large Crowd $220,000 $90,000 .20 PROFIT ($) Average Crowd $50,000 $70,000 .50 Small Crowd -$2,000 -$5,000 .30
March demand was pridicted at 590 units of gear cycles of trevaa ltd. But the actual demand was 400 units only so fourth the company now want to forecast the april demand using exponential smoothing model with constant alpha of 0.72., calculate the same
11. Provide an example for each type of approach to demand analysis.
Requirement Show your working calculation
Problem 2: Week Forecast Customer Orders Projected On-Hand Inventory MPS Available-to-Promise On-hand Inventory schedule production whenever projected on-hand inventory drops below MPS lot size Complete the master production schedule based on the following information 160 160 30 300 1 120 110 2 100 100 3 130 75 4 110 50 5 140 32 6 140 11 7 170 5 8 180 0
Explain the Purchasing Portfolio that is being used in McDonald's with a diagram
The units of Manganese Plus available for sale during the year were as follows: Mar. 1 June 16 Nov. 28 Inventory Purchase Purchase 23 units @ $29 32 units @ $30 42 units @ $36 97 units $667 960 1,512 $3,139 There are 14 units of the product in the physical inventory at November 30. The periodic inventory system is used. a. Determine the inventory cost by the FIFO method. $ b. Determine the inventory cost by the LIFO method. $ c. Determine the inventory cost by the weighted average cost methods. Round intermediate calculations and final answer to two decimal places.
Q7. The president of Rose Bowl Enterprises, Desmond Howard, projects the firms aggregate DEMAND requirements over the next 8 months as follows: These are the monthly DEMAND, not production. MONTH JAN FEB MAR APR MAY JUN JULY AUG DEMAND 1,400 1,600 1,800 1,800 2,200 2,200 1,800 1,800 PRODUCTION 1,600 from December INVENTORY 200 from Dec plus 200 His operations manager is considering a new plan, which begins in January with 200 units on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle time costs. The plan is called plan A. Plan A: Vary the workforce level to execute a strategy that produces the quantity demanded in the prior month. The December demand was given as 1,600 units per month. Therefore, the production for JAN will be 1,600. However, only 1,400 are needed. Therefore, the extra 200 produced go into inventory and there is a holding cost for inventory. Also, per the above, you already have 200 units in inventory…
Q3 The Muscat Chocolate Company produces all types of chocolate candy that is boxed before being sent to the retail outlets. After the chocolate has been poured, the candy production goes through all types of operation from adding fillings, shaping, decorating, coating, and the like, before being put into boxes, wrapped, and put into cartons. This production/assembly operation operates for 5 days/week, 8 hours/day. Weekly demand of boxes of the chocolates is shown in Table Q3. Production/packaging consists of 9 operations. These together with estimated time for completion, are given in Table Q3. Determine the following: (i) Draw the precedence diagram; (ii) The cycle time and theoretical number of workstations; (ii) The efficiency of the assembly line if the most tasks following rule/criteria is being followed. Table Q1 Weekly Demand Operations A B 6,100 Time (sec) Precedence 6. 8. A 9 B 11 12 B C. D A F 14 G 9 F 5 E 12 G, H
Question 4 Right now is Quarter 2 of 2020. You are developing an aggregate production plan for 2021. rvey Suppose the beginning inventory at the first quarter of 2021 is estimated to be 196 units. ing The demand for Quarter 1 of 2021 is forecasted to be 1.208 units while the demand for Quarter 2 2021 is forecasted to be 891 units. Overtime production and subcontract will not be available in the first two quarters of 2021. If the regular production in Quarter 1 is 1,950 units and the regular production in Quarter 2 is 891 units, what is the ending inventory level in Quarter 2 of 2021?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS