Q 4. The Wicked Witch Whisk Company manufactures a lineof broomsticks. The most popular is the 36-inch model, andthe sales department has prepared a forecast for 6 weeks.The opening inventory is 90. As master scheduler, youmust prepare an MPS. The brooms are manufactured in lotsof 120.Week1 2 3 4 l5 6Forecast Sales70 80 50 60 50 70Projected AvailableBalance90MPS

Master Production Scheduling (MPS) is a method in production to select which goods to produce and…

Answered: Q 4. The Wicked Witch Whisk Company…

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

Purple just sold Fred $4.9 billion of computer equipment. Fred immediately takes delivery and pays $1.6 billion in cash upon taking delivery; the remaining $3.3 billion is due n 30 days. Inventory associated with the order is $2.4. Ignore taxes. What is the impact of this transaction on: a. Revenues, b. Earnings, c. Receivables, d. Inventory, e. Cash Question content area bottom Part 1 a. Revenues change by $negative 3.3−3.3 billion. (Round to one decimal place. Use a negative sign for a decrease in value.) b. Earnings change by $enter your response here billion. (Round to one decimal place. Use a negative sign for a decrease in value.) c. Receivables change by $enter your response here billion. (Round to one decimal place. Use a negative sign for a decrease in value.) d. Inventory changes by $negative 9−9 billion. (Round to one decimal place. Use a negative sign for a decrease in value.) e. Cash changes by $enter your response here million.…
1. Forrest and Dan make boxes of chocolates for which the demand is uncertain. Forrest says, "That's life." On the other hand, Dan believes that some demand patterns exist that could be useful for planning the purchase of sugar, chocolate, and shrimp. Forrest insists on placing a surprise chocolate-covered shrimp in some boxes so that "You never know what you'll get." Quarterly demand (in boxes of chocolates) for the last three years is shown in the table below: b. If the expected sales for chocolates are 14,400 cases for year 4, use the multiplicative seasonal method to prepare a forecast for each quarter of the year. (Round all intermediate calculations to two decimal places.) The first quarter forecast is what? boxes of chocolates. (Enter your response rounded to the nearest whole number.)
Q2) Clancy's Motors has the following demand to meet for custom manufactured fuel injector parts. The holding cost for that item is $2 per month and each setup costs $80. Lead time is 0 months. Calculate the planned order releases using: (a) the EOQ technique, and (b) the POQ technique. And What are the costs of each plan, including the holding cost of any inventory left over after month 7? What technique performance is better. Month 1 2 3 4 5 6 7 Requirement 400 150 200 150 100 150 250 Answer: (a) The monthly holding cost = $2/month Average monthly demand = ??? units The EOQ = ??? units Total inventory held = ??? units Setup costs = $??? Holding cost = $???? Total cost = $???? (b) POQ Interval = ?.??, round to # month. Total inventory held = ? units Setup costs = $??? Holding cost = $? Total cost = $???
How would you adjust MPS schedule when safety stock requirements are given?
Q: A hardware company stocks nuts and bolts and orders them from a local supplier once every 2 weeks (10 working days). Lead time is 2 days. The company has determined that the average demand for 1⁄2 inch bolts is 150 per week (5 working days), and it wants to keep a safety stock of 3 days’ supply on hand. An order is to be placed this week, and the stock on hand is 130 bolts.a. What is the target level?b. How many 1⁄2 inch bolts should be ordered this time?
Q1) Consider the following requirements for a certain product. Period 1 2 3 4 5 6 7 8 Gross requirements 0 200 200 500 0 400 0 400 Beginning inventory = 300 units Setup cost = $300 per setup Lead time = 1 week Holding cost = $5 per unit per week (a) Develop the lot-for-lot MRP table - (complete table below). (b) Calculate the total relevant costs. Answer: a) Period 1 2 3 4 5 6 7 8 Gross requirements On hand beg period | 300 On hand end period Net requirements Order receipt Order release b) Total relevant costs = $?,???.
A steel workshop of PT Mental Baja produces leaf springs for cars. theyhave a demand forecast for the next 6 months as anext:i. January 446 units (production time 20 days)ii. February 600 units (production time 18 days)iii. March 700 units (production time 20 days)iv. April 900 units (production time 20 days)v. May 650 units (production time 20 days)vi. June 550 units (production time 20 days) The following are some important information to be the basis for doingcalculation of production costs as follows:i. Inventory cost $4 per unitii. Subcontractor fee $15 per unitiii. Workers cost $10 per hour or $80 per dayiv. Production time per unit 1.6 hours Tasks and questionsa. Assuming that the number of units that can be produced is 35 units per dayand 1 person can make 7 units, make an estimated cost by usingConstant Workforce approach. b. Assuming that internal processing is carried out usingcapacitors of daily production are the lowest for 6 months and constant,calculate estimated…
D&R A3 3 - 2 Question 3. FRA Pricing, Valuation, Payoff, and Hedging Today is June 1. Sustainable Corporation has an obligation of $25 million coming due on August 1. The company is planning to borrow this amount on August 1 to fulfill its obligation, and plans to pay back the loan on December 1. The company’s borrowing rate is LIBOR + 125 basis points. The company’s bank presents it with the following LIBOR term structure: # days LIBOR 30 0.90% 60 1.00% 90 1.05% 120 1.10% 150 1.15% 180 1.18% 210 1.20% 240 1.21% For the calculation of interest, the bank assumes 30 days in a month, and 360 days in a year. Ms. Devro, the VP Finance of Sustainable, is worried that LIBOR will increase between June and August, thus increasing the company’s borrowing cost. She advises that the company enters into a forward rate agreement (FRA) with its bank to hedge its interest rate risk. She has asked you, the treasurer of the company, to…
A hospital must order the drug Porapill from DaisyDrug Company. It costs $500 to place an order and $30 toreview the hospital’s inventory of the drug. Annual demandfor the drug is N(10,000, 640,000), and it costs $5 to holdone unit in inventory for one year. Orders arrive one monthafter being placed. Assume that all shortages are backlogged.a Estimate R and the number of orders per year thatshould be placed.b Using the answer in part (a), determine the optimal(R, S) inventory policy. Assume that the shortage costper unit of the drug is $100.
A clothing manufacturing company requires raw materials for 8 consecutive weeks as follows: 30, 40, 50, 35, 60, 30, 40, and 30 units with a one-time order cost of $50,000 and a storage fee of $500 per unit/week. From these data calculate the total cost of procurement using:a. Lot For Lot (LFL) Methodb. Economic Order Quantity (EOQ) Methodc. Period Order Quantity (POQ) Method Using this table format: Week 1 2 3 4 5 6 7 8 Gross requirements Schedule receipts Projected on hand Net requirements Planned order receipts Planned order releases
ABC analysis on the following set of products Item Annual Demand Unit CostA 211 800 R9B 390 100 R90C 003 450 R6D 100 400 R100E 707 85 R2,000F 660 250 R320G 473 500 R75H 921 100 R75 Soft goods department sells 175 units per month of a certain large bath towel. The unit cost of a towel to the manufacturer is R2.50 and the cost of placing an order has been estimated to be R12.00. There is an inventory carrying charge of 27% of the unit cost per year. What is the optimal order quantity, the order frequency, and the annual holding and setup cost. If the ordering cost can be cut to R4.00, what will be the new economicorder quantity, the order frequency, and annual holding and setup costs.
SLO 9.1. Blanket purchase orders: a.Reduce costs by decreasing the number of purchase orders issuedb.Cover multiple purchase requirements on one orderc.Are difficult to prepared.Reduce costs by decreasing the number of purchase orders issued and cover multiple purchase requirements on one ordere.Reduce costs by decreasing the number of purchase orders issued, cover multiple purchase requirements on one order, and are difficult to prepare

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS