need a excel formula 4. The Spencer Optics Company produces an inexpensive line of sunglasses. The manufacturingprocess consists of assembling two plastic lenses (produced by the firm's plastic molding depart-ment) into a finished frame (purchased from an outside supplier). The company is interested inusing material requirements planning to schedule its operations and has asked you to prepare anexample to illustrate the technique.The firm's sales manager has prepared a 10-week sales forecast for one of the more popularsunglasses (the Classic model) for your example. The forecast is 100 units per week. Spencer hascustomer orders of 110 units, 80 units, 50 units, and 20 units in weeks 1, 2, 3, and 4, respectively.The sunglasses are assembled in batches of 300 units. Presently, three such batches are sched-uled: one in week 2, one in week 5, and one in week 8.Complete the following time-phased record:Classic ModelOnMPS RecordForecastOrdersProjected availablebalanceAvailable-to-promiseMPSWeekhand 12345678910140

SOLUTIONGiven Informationlet's break down the informationBy the using these excel formulas in the…

Answered: 4. The Spencer Optics Company produces…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter12: Queueing Models

Section: Chapter Questions

Problem 59P

See similar textbooks

Similar questions

Electro Fans has j ust received an order for one thousand 20-inch fans d ue week 7. Each fan consists of a housing assembly, two grill s, a fan assembly, and an electrical unit.The housing assembly consists of a frame, two supports, and a handle. The fan assembly consists of a hub and five blades. The electrical unit consists of a motor, a switch, and a knob.The following ta ble gives lead times, on-hand inventory, and scheduled receipts.a) Construct a product structure.b) Construct a time-phased product structure.c) Prepare a net material requirements plan.
ADVANCED ANALYSIS Linear equations for the consumption and saving schedules take the general form: C = a + bY and S = -a + (1-b)Y where C, S, and Y are consumption, saving, and national income, respectively. The constant a represents the vertical intercept, and b represents the slope of the consumption schedule. a. Use the following data to substitute specific numerical values into the consumption and saving equations. Instructions: If you are entering any negative numbers be sure to include a negative sign (-) in front of those numbers. C = $ Y. S = $ Y. b. What is the economic meaning of b? . What is the economic meaning of (1 – b)? .
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…
Wal Mart, although they are not a manufacturing company, uses sophisticated computer software to forecast sales and order products to be stocked in their stores so that they do not run out of the things shoppers are looking for. What kind of software system does Wal Mart likely use? Group of answer choices a) Inventory control b) Just-in-time ordering c) E-procurement d) Materials Requirement Planning (MRP)
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…
Chelsea Jacobson awaited the arrival of her bed and dresser one Saturday in September. She’dpurchased the items in the IKEA Brooklyn store twelve days before, and couldn’t wait to finally bedone with sleeping on the floor of her apartment. She needed to be well rested as she headed toher writing job in Hell’s Kitchen.Although she’d been given a delivery window for the furniture to arrive, her bed and dresser never came.She contacted the shipping company, XPO Logistics, to get an update on the status of her items, butXPO notified her that IKEA had never supplied the order. Jacobson contacted IKEA numerous timesand eventually found out it could take an additional 4-6 weeks for her items to arrive, as they had been misplaced.Jacobson joins the ranks of customers who have fallen victim to IKEA’s troubled customer service.After attempts to contact the company via email and phone proved unsuccessful, she turned toTwitter to voice her complaints and warn others, only to find thousands of…
Mrs. Peters needed to raise money to bring her class to the Air and Space Museum in Washington, D.C. With only a few weeks left before the deadline, the class was raising an average of $45 every day from online donations. Mrs. Peters was worried they might not raise the last $1,000 in time. That evening, she posted a story about the class trip on an education website, and the donation rate doubled overnight! The new rate stayed the same for the remaining 3 weeks until the deadline, and they raised more than their goal! How much extra did the class raise?
A manufacturing company produces single item product. Theproduction manager decide to arrange 6 periods for MPS. Data aboutdemand forecasts are 112, 157, 126, 176, 124 and 181 while data aboutcustomer orders are 128, 156, 196, 147, 152 and 175. On hand inventoryis 300 units and production batch is 300 units. The productionmanager also decide that 3 beginning periods are critical, so that nochanges are allowed. Arrange MPS for that situation ! When system’s bottleneck requires 10 minutes to finish a unit product,make analysis about capacity. What is your suggestion? please explain it using excel or attached the excel sheet
24___________ is an activity that determines what quantity of materials have to be procured and when: Select one: a. Aggregate planning b. Replenishment planning c. Purchase planning d. Demand planning
Planners for a company that makes several models of skateboards are about to prepare theaggregate plan that will cover six periods. They have assembled the following information.Period 1 2 3 4 5 6 TotalForecast 200 200 300 400 500 200 1,800CostsOutputRegular time = $2 per skateboardOvertime = $3 per skateboardSubcontract = $6 per skateboardInventory = $1 per skateboard per period on average inventoryBack orders = $5 per skateboard per periodThey now want to evaluate a plan that calls for a steady rate of regular-time output,mainly using inventory to absorb the uneven demand but allowing some backlog. Overtimeand subcontracting are not used because they want steady output. They intend to start withzero inventory on hand in the first period. Prepare an aggregate plan and determine its costusing the preceding information. Assume a level output rate of 300 units (skateboards) perperiod with regular time (i.e., 1,800/6 = 300). Note that the planned ending inventory iszero. There are 15…
Macon Controls produces three different types of controlunits used to protect industrial equipment from overheating Each of these units must be processed by a machine thatMacon considers to be their process bottleneck. The plantoperates on two 8-hour shifts, 5 days per week, 52 weeks peryear. Table 4.2 provides the time standards at the bottleneck,lot sizes, and demand forecasts for the three units. Becauseof demand uncertainties, the operations manager obtainedthree demand forecasts (pessimistic, expected, and optimis-tic). The manager believes that a 20 percent capacity cushionis best.a. How many machines are required to meet minimum(pessimistic) demand, expected demand, and maximum(optimistic) demand?b. How many machines are required if the operations man-ager decides to double lot sizes? c. If the operations manager has three machines and be-lieves that the plant can reduce setup time by 20 percentthrough process improvement initiatives, does that planthave adequate capacity to…
Based on Quinn et al. (1991). Winter Riggers handles approximately $400 million in telephone orders per year. Winter Riggers’ system works as follows. Callers are connected to an agent if one is available. Otherwise, they are put on hold (if a trunk line is available). A customer can hang up at any time and leave the system. Winter Riggers would like to efficiently manage the telephone system (lines and agents) used to process these orders. Of course, orders are very seasonal and depend on the time of day. a. What decisions must Winter Riggers make? b. What would be an appropriate objective for Winter Riggers to minimize (or maximize)? What difficulties do you see in specifying the objective? c. What data would Winter Riggers need to keep track of to improve its efficiency?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS