Demand for a product is forecasted for the six periods is 263, 256, 301, 312, 304, and 294 respectively. If a CHASE DEMAND strategy is adopted, and the regular production cost is RO 12 per unit with a maximum regular production of 280 units per period. While, the overtime and subcontract costs are RO 20 and RO 25 per unit respectively. There is no limit on subcontracting; however, maximum overtime production capacity is 10. Average inventory holding cost is RO 5 per unit per period. How many units in total are held as inventory? Select one: O a. 51 O b. None is correct Oc 1629 O d. 40 e. 0

Demand for a product is forecasted for the six periods is 263, 256, 301, 312, 304, and 294 respectively. If a CHASE DEMAND strategy is adopted, and the regular production cost is RO 12 per unit with a maximum regular production of 280 units per period. While, the overtime and subcontract costs are RO 20 and RO 25 per unit respectively. There is no limit on subcontracting; however, maximum overtime production capacity is 10. Average inventory holding cost is RO 5 per unit per period. How many units in total are held as inventory? Select one: O a. 51 O b. None is correct Oc 1629 O d. 40 e. 0

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

1. Foxie Owl’s Besty Bagel shop makes fresh bagels. She has to buy raw materials fresh every day for selling on that day. She wants to know exactly how much should she spend on raw materials. Foxie did some analysis over the past month and came back with the following numbers: Daily demand was equally likely to be 200, 225, 250, 275, or 300 bagels. What should be the number of bagels on hand to satisfy a Fill Rate requirement of 96%, rounded to next integer value? Group of answer choices 300 275 286 263 2. Suppose that instead of a discrete demand distribution, Foxie’s shop determines that the daily demand for bagels is normally distributed, with a mean of 250 and a standard deviation of 35. Foxie still wants a Fill Rate of 98%. What is the appropriate level of on-hand inventory for Foxie’s shop? Group of answer choices 263 274 257 270
A small textile company makes several types of sweat-ers. Demand is very seasonal, as shown by the follow-ing quarterly demand estimates. Demand is estimated interms of standard hours of production required.An hour of regular time costs the company $12. Employees are paid $18 per hour on overtime, andlabor can be subcontracted from the outside at $14per hour. A maximum of 1000 overtime hours isavailable in any month. A change in the regular level of production (increase or decrease) incurs a one-time cost of $5 per hour for adding or subtracting anhour of labor. It costs 2 percent per month to carry an hour of finished work in inventory. Materials and overhead costs in inventory are equal to the directlabor costs. At the beginning of the fall quarter,there are 5000 standard hours in inventory and theworkforce level is equivalent to 10,000 standardhours.a. Suppose management sets the level of regular work-ers for the year equal to the average demand andsubcontracts out the rest. What is…
12. Zan Azlett and Angela Zesiger have joined forces to start A&Z Lettuce Products, a processor of packaged shredded lettuce for institutional use. Zan has years of food processing experience, and Angela 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 bag of lettuce. They think a largely manual process will have monthly fixed costs of $36,000 and variable costs of $1.75 per bag. A more mechanized process will have fixed costs of $72,000 per month with variable costs of $1.25 per bag. They expect to sell the shredded lettuce for $2.75 per bag. Part 2 a) The break-even quantity in units for the manual process = ______ bags (round your response to the nearest whole number). b) The revenue for…
Exercise 3: Daily demand for a product of a computer manufacturer is 400,000 units. The company, on average, makes $150 net profit for each computer. The current fill rate is 86%. About 70% of their incomplete orders are back-ordered, and the rests are cancelled. The company is considering to improve the fill rate to 90% whose estimated daily additional operating cost (e.g.,improving the warehousing and transportation) is $2,000,000. What should be the minimum back-order cost to make this investment reasonable?
Old Pueblo Engineering Contractors creates six-month “rolling” schedules, which are recomputed monthly. For competitive reasons (it would need to divulge proprietary design criteria, methods, and so on), Old Pueblo does not subcontract. Therefore, its only options to meet customer requirements are (1) work on regular time; (2) work on overtime, which is limited to 30 percent of regular time; (3) do customers’ work early, which would costan additional $5 per hour per month; and (4) perform customers’ work late, which would cost an additional $10 per hour per month penalty, as provided by their contract. Old Pueblo has 25 engineers on its staff at an hourly rate of $30. The overtime rate is $45. Customers’ hourly requirements for the six months from January to June are January 5000 February 4000 March 6000 April 6000 May 5000 June 4000 Develop an aggregate plan using a spreadsheet. Assume 20 working days in each month. 12. Alan Industries is expanding its product line to include three…
c. Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number). MONTH PRODUCTION DAYS DEMAND FORECAST DEMAND PER DAY JAN 2022 16 150 ? FEB 2022 16 150 ? MAR 2022 23 250 ? APR 2022 21 250 ? MAY 2022 22 400 ? JUN 2022 22 500 ? JUL 2022 21 600 ? AUG 2022 20 750 ? SEP 2022 20 450 ? OCT 2022 20 250 ? NOV 2022 16 150 ? DEC 2022 16 150 ? TOTAL ? ? d. Assuming that MPQ Limited had adopted a level strategy for the year ended 31 December 2022, compute the average daily demand for the year (round off to the nearest whole number). e. Prepare a graph showing the monthly forecasts and average daily forecast (in units per day) for MPQ Limited.
Zan Azlett and Angela Zesiger have joined forces to start A&Z Lettuce Products, a processor of packaged shredded lettuce for institutional use. Zan has years of food processing experience, and Angela 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 bag of lettuce. They think a largely manual process will have monthly fixed costs of $40,000 and variable costs of $2.00 per bag. A more mechanized process will have fixed costs of $72,000 per month with variable costs of $1.25 per bag. They expect to sell the shredded lettuce for $3.00 per bag. a) The break-even quantity in units for the manual process = enter your response here bags (round your response to the nearest whole number). b) The revenue…
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January February 4,100 4,200 March 3,900 April 4,300 May 4,900 June 4,600 July 5,200 August 4,800 September 5,300 October 5,600 November 6,200 December 5,900
Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…
Problem 11-11 (Algo) Famous Albert prldes himself on being the Cookle King of the West. Small, freshly baked cookles are the specialty of his shop. Famous Albert has asked for help to determine the number of cookles he should make each day. From an analysis of past demand, he estimates demand for cookles as VROBARTLITY OF DENAND 0.04 DEEAND 1,800 dosen 2,000 2,200 0.10 0.20 2,400 2,600 2,000 3,000 0.26 0.15 0.03 0.14 ces Each dozen sells for $0.65 and costs $0.49, which includes handling and transportation. Cookles that are not sold at the end of the day are reduced to $0.30 and sold the following day as day-old merchandise. a. Compute the expected profit or loss for each cookie making decislon quantity. (Round your answer to the nearest whole number. Enter expected losses with a negative sign.) Cookles Baked (Dozen) Probability of Demand Expected Profit/Loss 1,800 0.04 2,000 0.10 2,200 0.28 2,400 0.26 2,600 0.15
Tuff-Rider, Inc., manufactures touring bikes and mountain bikes in a variety of frame sizes, colors, and component combinations. Identical bicycles are produced in lots of 110. The projected demand, lot size, and time standards are shown in the following table: i Item Demand forecast Lot size Standard processing time Standard setup time Touring 4,000 units/year 130 units 0.20 hour/unit 2 hours/lot Mountain 10,000 units/year 110 units 0.50 hour/unit 3 hours/lot The shop currently works 8 hours a day, 5 days a week, 48 weeks a year. It operates five workstations, each producing one bicycle in the time shown in the table. The shop maintains a 15 percent capacity cushion. How many workstations will be required next year to meet expected demand without using overtime and without decreasing the firm's current capacity cushion? The number of workstations required next year is. (Enter your response rounded up to the next whole number.)
. Case: Flamingo Educational Services Flamingo Educational Services, a company located in the Tema metropolis, is a nationwide market leader in the publishing and distribution of textbooks for first and second cycle schools. Somehow, Flamingo does not use forecasts for production planning. Instead, the operations manager decides which books to produce and the batch size, based on orders and the amounts in inventory. The books that have the fewest amounts in inventory get the highest priority. Demand is uneven, and the company has experienced being overstocked on some items and out of others. Being under-stocked has occasionally created tensions with managers of the retail bookstores the company works with. Flamingo is on the verge of losing a lucrative contract with the Ghana Education Service over a complaint that the books produced over the last four months have defective binding as well as slight but noticeable variations in print quality and sizes of the…