SPREADSHEET PROBLEMS 1. Given the following production plan, use a (a) chase production strategy and (b) level production strategy to compute the monthly production, ending inventory/(back- log), and workforce levels. A worker can produce 100 units per month. Assume the

SPREADSHEET PROBLEMS 1. Given the following production plan, use a (a) chase production strategy and (b) level production strategy to compute the monthly production, ending inventory/(back- log), and workforce levels. A worker can produce 100 units per month. Assume the

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

Develop a production schedule to produce the exact production requirements by varying the workforce size for the following problem. Also, evaluate the cost of the schedule. Use the example in the chapter as a guide (Plan 1). The monthly forecasts for Product X for January, February, and March are 1,000, 1,500, and 1,200, respectively. Safety stock policy recommends that half of the forecast for that month be defined as safety stock. There are 22 working days in January, 19 in February, and 21 in March. Beginning inventory is 500 units. Manufacturing cost is $200 per unit, storage cost is $3 per unit per month (based on expected end-of-month levels), standard pay rate is $6 per hour, overtime rate is $9 per hour, cost of backorder is $10 per unit per month, marginal cost of subcontracting is $10 per unit, hiring and training cost is $200 per worker, layoff cost is $300 per worker, and worker productivity is 0.1 unit per hour. Assume that you start off with 50 workers and that they work…
EXAMPLE: PRODUCTION PLAN STRATEGIES 1. Prepare the production plan using the three basic production plan strategies Suppose the forecasted demand for a product family looks like the table below. Assume the product family is a make to stock family with a starting inventory of 210. Period 1 2 3 4 5 6 Total Forecast 175 150 180 165 150 200 1020 (Demand) Additional Information: For Hybrid production, it is assumed that for the 1* three periods it uses the lowest demand; on the 4th and 5th period it uses 175 forecasted demand; and on the 6th period there is no change on the demand. Requirement: Solve for the following a. Chase production plan Period 1 2 3 4 5 6 Total Forecast (Demand) 175 150 180 165 150 200 1020 Level production plan Period 1 2 3 4 5 6 Total Forecast (Demand) 175 150 180 165 150 200 1020 b. Hybrid production plan Period 1 4 5 6. Total Forecast (Demand) 175 150 180 165 150 200 1020
Sterling's worksheet, Intake vs.Goals Report & Food Log. Sterling is 30 years old college graduate. Currently he works for the federal government as program analysis. During the pandemic Sterling was promoted, work has been extremely busy. Dusty working from home, he has had little time to cook or exercise. During this annual physical, the doctor reported that he had gained 50 pound. Sterling wonderd it eat came from the beer, he drank 1 every evening. Sterling exercises about an hour on Saturday and Sundays. He used exercise daily when he was college athlete. His lab work and blood pressure were not the best either. The doctor counseled him and referred him to the nutrient. Sterling shared that his father saferd heart attack at age 50 and his mother has hypertension, he realizes that this risk for cardiovascular disease
The following information relates to a company’s aggregate production planning activities: Quarter Demand Forecast 1 75,000 2 100,000 3 75,000 4 125,000 Beginning Workforce = 35 workers Production per Employee = 1,250 units per quarter Hiring Cost = $500 per worker Firing Cost = $1,000 per worker Inventory Carrying Cost = $20 per unit per quarter If a level production strategy is used then the cost of the level production plan (inventory costs plus hiring and firing costs) is a) $20,000. b) $645,000. c) $1,250,000. d) $1,270,000. Answer: d Pls explain with steps
The forecasted demand for fudge for the next four months is 110, 140, 230, and 160 pounds. What is the recommended production rate if a level strategy is adopted with no backorders or stockouts? What is the ending inventory for month 4 under this plan? Round your answers to the nearest whole number. Production rate: pounds/month Ending inventory (month 4): pounds What is the level production rate with no ending inventory in month 4? Round your answer to one decimal place. Production rate: pounds/month
A Pizza Company has a demand forecast for the next 12 months that is shown in Table 1 The current workforce of 100 staff can produce 1500 cases of pizzas per month. (a) Prepare a production plan that keeps the output level. How much warehouse space would the company need for this plan? (b) Prepare a demand chase plan. What implications would this have for staffing levels, assuming that the maximum amount of overtime would result in production levels of only 10 per cent greater than normal working hours? Table 1 demand forecast Month Demand (cases per month) January 600 February 800 March 1000 April 1500 May 2000 June 1700 July…
Please do not give solution in image format thanku XYZ Mobile makes phones in multiple production lines. The daily production run is for 820 phones. Each phone has a standard time of 5.1 minutes. Each production line operates for 9 hours per day. Do not include commas in your answer and enter percentages as decilmal points. For example enter 1,402 as 1402 and 67.5% as 0.675. How many production lines are needed to meet the daily demand? What is the utilization of the production lines? What is the maximum daily output of the system?
The term in the airline industry may be used to refer to s situation where an empty seat is recorded on a flight. Select one: a. Marginal cost b. Overhead cost c. Marginal loss d. Revenue loss Widner Industries reports annual sales of Ghc160 million, cost of goods sold of Ghc120 million, inventory of Ghc20 million, and net income of Ghc5 million. What is Widner's annual inventory turns? Select one: a. 8 turns per year b. 6 turns per year c. 0.17 turns per year d. 4 turns per year
Determine which factor of production is needed in the following problem. 1.The ABM manufacturing Co.hired a gardener.He uses a lawn mower for landscaping.Which factor of production would you consider this machine? 2.The owner of the company withdrew cash for the salaries of thw employees.which factor of production would you consider cash on hand? 3.The top manager of the firm said "the great ideas,consepts and emotional determination of a person to produce something that consumers want to buy" is very important for the company.What factor of production describes the ability to create great ideas? 4.The farmers planted pineapple cutting in the vacant area located in their locality.Which factor of production would you consider a pineapple plantation?
Well water inc. wants to produce and sell a new flavored water in order topenetrate the market, the product will have to sell at 2.60 per 12 oz bottle thefollowing data has been collected: Annual sales 50,000 bottlesProjected selling and administrative costs 8,000Desired profit 80,000The target cost per bottle is _____ per bottle (2 decimal places)
Zhu Manufacturing is considering the Introduction of a family of new products. Long-term demand for the product group is somewhat predictable, so the manufacturer must be concemed with the risk of choosing a process that is inappropriate. Faye Zhu is VP of operations. She can choose among batch manufacturing or custom manufacturing, or she can invest in group technology, Zhu won't be able to forecast demand accurately until after she makes the process choice. Demand will be classified into four compartments: poor, fair, good, and excellebt The table below indicates the payoffs (profits) associated with each processidemand combination, as well as the probabilities of each long-term demand level: Demand Poor Fair Good Excellent Probability Batch Custom 0.15 0.40 -$300,000 $100,000 $1,200,000 $800,000 $400,000 $00,000 0.30 $1,200,000 $750,000 $500,000 0.15 $1,300,000 $800,000 $2,200,000 Group technology a) The alternative that provides Zhu the greatest expected monetary value (EMV) is…
3-2) The optimal quantity of the three products and resulting revenue for Taco Loco is: A) 28 beef, 80 cheese, and 39.27 beans for $147.27. B) 10.22 beef, 5.33 cheese, and 28.73 beans for $147.27. C) 1.45 Z, 8.36 Y, and 0 Z for $129.09. D) 14 Z, 13 Y, and 17 X for $9.81. 3-3) Taco Loco is unsure whether the amount of beef that their computer thinks is in inventory is correct. What is the range in values for beef inventory that would not affect the optimal product mix? A) 26 to 38.22 pounds B) 27.55 to 28.45 pounds C) 17.78 to 30 pounds D) 12.22 to 28 pounds