A local manufacturer of toys produces several toys. Among the most popular is Disney-car toy model. Suppose that there are currently 100 Disney-car toys in inventory and that there are customer orders that have been committed and must be filled. Suppose that a production lot size of 150 Disney-car toys. The weekly forecasts for the eight weeks are 176, 172, 50, 130, 40, 120, 132, and 135 respectively. The customer orders for weeks 1, 2, 3 through 8 are the 88, 86, 25, 65, 20, 51,0,0 respectively. Using the standard principles of Master Production Schedule (MPS) along with Available-To-Promise (ATP) for the Disney-car toys, what is the maximum number of the projected held in inventory in any given week? O a. 132 O b. 52 O c. 74 O d. None is correct O e. 100

A local manufacturer of toys produces several toys. Among the most popular is Disney-car toy model. Suppose that there are currently 100 Disney-car toys in inventory and that there are customer orders that have been committed and must be filled. Suppose that a production lot size of 150 Disney-car toys. The weekly forecasts for the eight weeks are 176, 172, 50, 130, 40, 120, 132, and 135 respectively. The customer orders for weeks 1, 2, 3 through 8 are the 88, 86, 25, 65, 20, 51,0,0 respectively. Using the standard principles of Master Production Schedule (MPS) along with Available-To-Promise (ATP) for the Disney-car toys, what is the maximum number of the projected held in inventory in any given week? O a. 132 O b. 52 O c. 74 O d. None is correct O e. 100

Name: A local manufacturer of toys produces several toys. Among the most po
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: A local manufacturer of toys produces several toys. Among the most popular is Disney-car toy model. Suppose that there are currently 100Disney-car toys in inventory and that there are customer orders that have been committed and must be filled. Supp

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
Mona PLC is a Zambian well-known company that sells goods locally within Zambia. The recently appointed Management Accountant of Mona PLC has been studying the working capital management of the company and has congregated the following information: Inventory management the current policy is to order 100,000 units when the inventory level reduces to 35,000 units. Prediction demand to meet production requirements during the next year is 625,000 units. The cost of placing and processing an order is K250, while the cost of holding a unit in stores is K0.50 per unit per year. Both costs are expected to be constant during the next year. Orders are received two weeks after being placed with the supplier. You should assume a 50- week year and that demand is constant throughout the year. Accounts receivable management Local customers are allowed 30 days’ credit, but the financial statements of Mona PLC shows that the average accounts receivables period in the last financial year was 75 days.…
. Worldwide Can-Openers, Inc., makes a family of two hand-operated can openers. The production plan is based on months. There are 4 weeks in this month. Opening inventory is 2000 dozen, and it is planned to increase that to 4000 dozen by the end of the month. The MPS is made using weekly periods. The forecast and projected available balance for the two models follow. The lot size for both models is 1000 dozen. Calculate the production plan and the MPS for each item.
a company manufactures an assortment of products for the practice of recreation and leisure. total demand for the next seven months is the following: mois march april may june july aug sept total forecasts 50 44 55 60 60 40 50 359 use the following info to develop aggregate production schedules regular production costs: $240 per unit overtime production cost: $360 per unit regular capacity: 40 units per month overtime capacity: 8 units per month subcontracting cost: $420 per unit subcontract capacity: 12 units per month back order cost: $100 per unit per month initial inventory: 0 End inventory in September: 0 unit storage cost: $30 per unit per month (the monthly inventory cost is calculated based on the final inventory for the month number of employees: 5 workers hiring cost: $2,000 per employee thank you cost: $1,000 per month Prepare an overall production plan using each of the following guidelines and calculate the total cost for each program. Even if backorders are…
A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of .99. The order interval is 12 days, and lead time is 4 days. Average demand for one item is 63 units per day, and the standard deviation of demand is 6 units per day. Given the on-hand inventory at the reorder time for each order cycle shown in the following table. Use Table. Cycle On Hand 1 38 2 10 3 93 Determine the order quantities for cycles 1, 2, and 3: (Round your answers to the nearest whole number) Cycle Units 1 1019 Numeric ResponseEdit Unavailable. 1019 incorrect. 2 1047 Numeric ResponseEdit Unavailable. 1047 incorrect. 3 964 Numeric ResponseEdit Unavailable. 964 incorrect.
The table below provides demand data for 6 weeks (weeks 31-36 for the current year) for one product. Inventory is managed with a periodic review system where T = 5 weeks and M = 280. The previous order was for 120 units at the end of week 28. The lead time is a constant 4 weeks. At the beginning of week 31 the inventory level is 130 units. Orders are made at the end of a week. 1. When is the next order? end of week __________ 2. How large is the next order? ___________ Week Demand Inventory 31 30 32 40 33 45 34 30 35 30 36 30
(2-b) A firm's demand in the next four quarters is forecast to be 400, 600, 800, and 700 units. Given that beginning inventory is 600, desired ending inventory in quarter 4 is 300, inventory holding cost is $6 per unit per quarter, and production cost is $50 per unit, calculate the cost of a level production plan.
A retailer has two merchandizers, Sue and Bob, who are responsible for setting orderquantities for the products they manage. For all of their products, the critical ratio is .7and the coefficient of variation of their demand forecasts is 0.35. At the end of the season, Sue is proud to report that she has sold the entire inventory she purchased. Bob, onthe other hand, sold only about a third of his products. Who is more likely to be choosing quantities that maximize expected profit? a. Sue because she doesn’t incur the cost of salvaging inventory.b. Sue because she must have sold more units than Bob.c. Bob because even leftover inventory generates some additional revenue.d. Bob because he is probably ordering more than the mean of the demand forecast.
John buys goat milk at a cost of $5 per gallon from a local dairy and sells it for $8 per gallon in its store. The dairy will buy back any milk that is unsold at the end of the day for $2 per gallon. Each day John must determine how many gallons to order. Past sales have ranged between 15 and 18 gallons per day, according to the following demand pattern.Demand:15161718Number of days demand occurred:2486Assume that demand will be within this range in future.(a) What are the possible actions and states?(b) Determine the daily profit (rewards) and show on a reward table.(c) Using each of the following criteria, determine John’s best action.- Maximin- Maximax- Expected value(d) Construct the regret (opportunity cost) matrix and using minimax regret criteria determine John’s best action.
Usha Handling Company is currently faced with an inventory rotation problem. Thisdifficulty stems from the fact that some supplies must be used prior to a stated expiration date.Upon receipt, a new shipment of these perishable items must be stacked beneath the boxes that are currently in inventory. A substantial amount of time is consumed in restacking the items according to their expiration dates. The company would like to reduce the double and sometimes triple handling of items. How can this goal be achieved? Are there alternative solutions which might also be effective?
BicycleBro is a retailer that sells bicycles. The company had been operating for 30 days (1 month). By the end of 1 month it wants to measure its performance in terms of Inventory turnover and Days of inventory. Below is the information that the company has collected from its warehouse and accounting department Stock Count Sheet Item code Stock on hand Stock count week (week number when employees counted the stock on hand) 100 30 week1 200 10 week1 100 10 week3 200 20 week3 Inventory valuation Item code Value per unit (in $) 100 1000 200 2000 Bicycles sold by end of month Item code Units sold 100 5 200 10 Given the information above find What is the total inventory turnover rate for given period? What is the total Inventory Days of Sales for given period?
Suppose that an organization is engaged in the manufacturing and sales of a seasonal product. Based on a sales forecast of 1000, 500, 500, and 2000 per quarter, calculate a level production plan, quarterly ending inventory, and average quarterly inventory. If inventory carrying costs are $7 per unit per quarter, what is the annual cost of carrying inventory? Assume that the opening and ending inventories are zero. (With steps)