The president'of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as followsJanuaryFebruary1,4501,600May2,3002,2001,900JuneMarch1,7001,700JulyAprilAugust1,300Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $60 per unit. Inventory holding cost is $20 per unit per month Ignore any idle-lime costs. Evaluate the foilowing planThis exercise contains only Plan EPlan E Keep the current workforce, which is producing 1,600 units per month, and subcontract to meet the rest of the demand Subcontract cost is $75 per unit.Plan EProductionSubcontractEndingInventoryMonthO December1 JanuaryDemand(Units)(Units)2001,4501,6002 February1,6001,6003 March1,7001,6004 April1,7001,6005 May2,3001,6006 June7 July8 August2,2001,6001,9001,6001,3001,600The total subcontracting cost = S (Enter your response as a whole number)The total inventory holding cost for January through August = $. (Enter your response as a whole number.)The total cost, excluding normal time labor costs, for Plan E = S (Enter your response as a whole number.)

Given: Subcontracted cost per unit = 75 Inventory holding cost per unit = 20

Answered: The total subcontracting cost = sO…

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

Historical demands observed for the last 5 months are 1000, 2300, 3200, 1750, and 1200. To match the demand, the company placed respective orders of 1100, 2500, 4000, 1000, and 900 units. (a) Compute the variance of demand. (b) Compute the variance of orders. (c) Compute the bullwhip measure. Is there an amplifying or smoothing effect?
i need this answer urgent
A manufacturer procures a subassembly from a supplier. The annual demand is 145,000 units, the cost per unit is $4, the inventory-carrying charge is 12 percent, and the order cost is $225. For orders between 10,000 but less than 30,000, a five percent discount is applied, and for orders exceeding 30,000, a eight percent discount is applied. What is the optimal order quantity? Use the Quantity Discount Excel template to find your answer.
Please help me with show all calculation thanku
What is the typical method for developing a level growth plan in a made-to order setting?
Holding cost = $7 per unit per month Subcontracting cost = $65 per unit Regular time labor cost = $15 per hour. Each worker works 8 hours per day as regular time laborers Overtime labor cost = $19 per hour for hours above 8 hours per worker per day Hiring cost = $40 per worker Firing cost = $80 per worker Demand during the month of June = 640 units Labor hours per unit = 3 Beginning inventory in July = 150 units Please follow the outlined strategy accurately. The strategy is to fulfill the gross demand in each month, storing any excess units in a warehouse as inventory. The warehouse can only hold 300 units maximum, so any additional units that cannot be warehoused will have to be scrapped and sent to a recycler at a cost of $50 a unit. The recycler will dispose of the units in an environmentally friendly manner. The workers employed during a month, working 8 hours a day as regular time labor, produce exactly the gross demand in the previous month. For example, the regular time labor…
help me with a,b,c. thanks and explain too
Kaniri Global Imports (a retail store) sells artisan greeting cards. The owners search for localartists from around the world from whom to buy their greeting card inventory. The followinginformation is available to you for this problem:Demand/Sales = 110 cases of cards per yearOrdering or Setup Cost = $25 per orderCarrying Charge = 18% per yearUnit Cost = $150 per caseAnswer the following questions and be sure to show your computations. You can use whateversymbol you need for square root, if typing in Word.1. How many cases should be ordered at a time? (This number will be the EOQ). Computeto two decimal places. In reality they would round, but for this problem keep the twodecimal places.2. How many times should Kaniri order in a year? Do not answer in terms of how manydays or months, but rather how many times per year. Round your answer up to the nexthighest whole number.3. Answer all three:a. What is the annual cost of ordering the cards?b. What is the annual cost of carrying the…
David’s Delightful Kites Company (DDKC) manufactureskites. Th e most popular is David’s Daredevil model. Demandmanagement has prepared forecast estimates for the next sixweeks. Beginning inventory is 15 David’s Daredevils. As themaster scheduler for DDKC, you must prepare an MPS. Your MPSorder quantity is 72 kites. (a) Prepare the MPS using an order quantity of 72 kites.(b) Calculate the ending inventory for each period.(c) What is the maximum number of units held in inventory?(d) How many MPS orders are needed?
Problem 13-3 Determining the Time Value of Money [LO13-1] Complete the following table. Use Exhibit 1-A, Exhibit 1-B, Exhibit 1-C, Exhibit 1-D. Note: Use appropriate factor(s) from the tables provided. Round time value factors to 3 decimal pla nearest whole number. Annual Deposit Rate of Number of Return Years Investment Value at the End of Time Period Total Amount of Investment $ 3,000 4 % 9 $ 3,000 8% 9 $ 3,000 4 % 18 $ 3,000 8% 18 Total Amount of Interest or Earnings
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.
Under the last-in, first-out (LIFO) inventory valuation method, a price index for inventory must be established for tax purposes. The quantity weights are based on year-ending inventory levels. Unit Price ($) Product EndingInventory Beginning Ending A 500 0.15 0.19 B 50 1.40 1.80 C 100 4.50 4.20 D 60 12.00 13.60 Use the beginning-of-the-year price per unit as the base-period price and develop a weighted aggregate index for the total inventory value at the end of the year. (Round your answer to the nearest integer.) I = ?? What type of weighted aggregate price index must be developed for the LIFO inventory valuation? -Paasche index -Laspeyres Index

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

The total subcontracting cost = sO (Entor your response as a whole number) The total inventory holding cost for January through August = S (Enter your response as a whole number) The total cost, excluding normal time labor costs, for Plan E = S (Enter your respornse as a whole number.)