Please do not give image format TotalsCostsCost of planPlanning valuesStarting inventoryStarting and ending workforceHours worked per month per workerHours per unitHiring cost per workerLayoff cost per workerMonthly per-unit holding costranscribed TextMore InfoaPrintMonthMarchAprilMayJuneJulyAugustSeptemberOctoberJanuaryFebruaryĈForecastedsales1,3791,3231,0158331,5611,8832,0022,086November2,499December 2,4502,2191,715Layoff238$238,000DoneHiring Inventory23830,000$1,190,000 $240,000$1,668,0002,50023217525$5,000$1,000$8- XSIivFfiI Complete the chase production plan, using the following information. The only costs you need to consider here are layoff, hiring, and inventorycosts. If you complete the plan correctly, your hiring, layoff, and inventory costs should match those given here.Click the icon to view the costs table.Click the icon to view the forecasted sales.Fill in the production plan table below (enter your responses as whole numbers).Sales inworkerhoursMonthMarchForecastedsales1,379to meetsalesaverage = 250Actualworkers232ActualproductionLayoffsHiringEndinginventory2,500

Note: There is discrepancy in the values to match with final answer. Hence, the solution is provided…

Complete the chase production plan, using the following information. The only costs you need to consider here are layoff, hiring, and inventory costs. If you complete the plan correctly, your hiring, layoff, and inventory costs should match those given here. Click the icon to view the costs table.

Complete the chase production plan, using the following information. The only costs you need to consider here are layoff, hiring, and inventory costs. If you complete the plan correctly, your hiring, layoff, and inventory costs should match those given here. Click the icon to view the costs table.

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

Compare the chase planning strategy to the level planning strategy for developing sales and operations plans.
Mary Jones and Jack Smart have joined forces to start M&J Food Products, a processor of packaged shredded lettuce for institutional use. Jack has years of food processing experience, and Mary has extensive commercial food preparation experience. The process will consist of opening crates of lettuce and then sorting, washing, slicing, preserving, and finally packaging the prepared lettuce. Together, with help from vendors, they think they can adequately estimate demand, fixed costs, revenues, and variable cost per 5-pound bag of lettuce. They think a largely manual process will have monthly fixed cost of $50,000 and a variable cost of $2.50 per bag. They expect to sell 75,000 bags of lettuce per month. They expect to sell the shredded lettuce for $3.25 per 5-pound bag. Jack and Mary has been contacted by a vendor to consider a more mechanized process. This new process will have monthly fixed cost of $125,000 per month with a variable cost of $1.75 per bag. Based on the above…
Assume that a company provided the following information and assumptions from its master budget: Sales budget: Unit sales in June, July, and August are 20,000, 18,000, and 17,000, respectively. The selling price per unit is $80. All sales are on account. 20% of sales are collected in the month of sale and 80% are collected in the next month. What are the budgeted sales for July? Multiple Choice $1,440,000 $1,600,000 $288,000 $1,152,000
Mavis and John have joined forces to start M&J Food Products, a processor of packaged shredded lettuce for institutional use. John has years of food processing experience, and Mavis has extensive commercial food preparation experience. The process will consist of opening crates of lettuce and then sorting, washing, slicing, preserving, and finally packaging the prepared lettuce. Together, with help from vendors, they think they can adequately estimate demand, fixed costs, revenues, and variable cost per 5-pound bag of lettuce. They think a largely manual process will have monthly fixed cost of $50,000and a variable cost of $2.50 per bag. They expect to sell 75,000 bags of lettuce per month. They expect to sell the shredded lettuce for $3.25 per 5-pound bag. John and Mavis has been contacted by a vendor to consider a more mechanized process. This new process will have monthly fixed cost of $125,000 per month with a variable cost of $1.75 per bag. Based on the above scenario: Should…
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 Info Feb Mar Jun 49,000 51,200 49,000 Forecast (demand) Regular production Overtime production Subcontract production Ending inventory Hired employees Fired employees Total employees Cost variables are as follows: Cost Variables Labor cost/hour Overtime cost/unit Subcontracting cost/unit Holding cost/unit/month Hiring cost/employee Firing cost/employee Beginning Jan 45,000 7,200 160 $19 $34 $31 $11 $3,700 $5,800 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/SSD Regular production units/employee/month Max regular production/month Max overtime production/month Max subcontractor production/month 3 200 56,600 3,000 4,200 Apr May 62,600 45,600
“Mickey Limited is a manufacturing business that uses a standard costing system. The company’s flexed budget for April 20X9 is: Sales £173,340 Costs Direct materials (£22,500) Direct labour (£37,684) Variable production overheads (£15,520) Fixed production overheads (£49,400) Profit 48,236 The company’s directors are presented with the following standard cost operating statement for the month:” Total Original budgeted net profit £44,540 Favourable (Adverse) Sales profit volume variance £3,696 Sales price variance £424 Direct materials price variance £1,372 Direct materials quantity variance £2,560 Direct labour rate variance - - Direct labour efficiency variance £480 Production overhead variance £240…
Alignment of goals in the supply chain, such that all stages share the same competitive strategy and try to maximize the total supply chain profitability is known as а. revenue management. b. supply chain coordination. c. forecasting. d. aggregate planning.
1) Which of the following translates business plan into productionplanningAPPMPSMRPNone of the Above2) Master production schedule is a medium-range planning and it isused for quantity and timing ofcomponents and raw materialFinished goodsBoth A & B3) The manufacturing strategy which deploys hiring and laying ofworkers in order to match its production rate to demand is calledLevel Production StrategyChase Production StartegyHybrid StrategyNone of the above4) "In a level production strategy, if the firm makes annual 120,00units per annum, the permonth production can be estimatted by""120,00 /12""120,00 / 365"The information is not complete5) The Bill of material is an engineering documments that showsinclusive listing and sub-components to be used for end productTRUEFALSE6) A lead capacity usually increases or decreases its capacity in anticipation of demand, this is known as "Match strategyLead Capacity StrategyLag capacity strategy7) The most important output of MRP isBOMPlanned…
Mirabel Manufacturing is a small but growing company that manufactures and sells marine sonar equipment. They employ a national sales force and their primary customers are marine retailers and boat dealerships. The company has expanded over the last 5 years and Paul Mirabel, the founder, and CEO has become concerned that he no longer has a clear picture of their cost structure. He calls his CFO, Mary Jane Montgomery in for a meeting. “Mary Jane, I am concerned that I am not current on our cost structure and how that is impacting our bottom line,” Paul begins. “Well, Paul, the company has grown considerably over the past 5 years, so I’m not surprised that you feel a little disconnected with how things are going,” Mary Jane replied. She continued “In fact, I’ve been meaning to talk to you about a couple of big items such as increasing the sales commission to 15%. We’ve lost two of our best account managers in the last 9 months. It seems like we are behind the curve paying only 12% on…
What determines the length of the future time period for which a sales forecast must be prepared for operations planning purposes?
John Ozment, director of special projects and analysis for Ozment’s Corporation, is responsible for preparing corporate financial analyses and monthly statements and reviewing and presenting the economic impacts of proposed strategies to upper management. Data for such financial analyses are obtained from operations and financial databases through direct queries of Ozment’s department staff. Reports and charts for presentations are then prepared by hand and typed. Multiple copies are prepared and distributed to various users. The pressure on Ozment’s group has intensified as demand for more and more current information increases. A solution to this reporting problem must be found.The systems department wants to develop a proprietary software package to produce the reports automatically. The project would require the company to make a considerable programming investment. Ozment is concerned about the accuracy, completeness, and currency of data isautomatically produced reports. He has…
Please do not give solution in image formate thanku. Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 10,000; winter, 8,000; spring, 7,000; summer, 12,000. Inventory at the beginning of fall is 500 units. At the beginning of fall, you currently have 30 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. In addition, you have negotiated with the union an option to use the regular workforce on overtime during winter or spring if overtime is necessary to prevent stock outs at the end of those quarters. Overtime is not available during the fall. Relevant costs are hiring, $100 for each temp; layoff, $200 for each worker laid off; inventory holding, $5 per unit-quarter; backorder, $10 per unit; straight time, $5 per hour; overtime, $8 per hour. Assume that the productivity is 0.5 unit per worker hour, with eight hours per day and 60 days per season.