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

Eds of Edmond has decided to use a level strategy, keeping the number of employees constant, to keep employee goodwill. Ed's will use all of the following EXCEPT OA layoffs. OB. overtimelundertime. Oc. anticipation inventory. O D. backorders.
answer both parts
If D = 7,700 per month, S =$42 per order, and H = $2.00per unit per month, a) What is the economic order quantity? The EOQ is enter your response here units (round your response to the nearest whole number). b) How does your answer change if the holding cost doubles? The EOQ is enter your response here units (round your response to the nearest whole number). c) What if the holding cost drops in half? The EOQ is enter your response here units (round your response to the nearest whole number).
is not among one of the assumptions of the basic Economic Order Quantity (EOQ) model O a. Annual demand requirements are known and constant. Ob. Each order is received in a single delivery. Oc. Quantity discounts are available. O d. Lead time does not vary.
A large corporation maintains a fleet of three 30-passenger corporate jets that provide daily scheduled service between Detroit & several cities that are home to its production facilities. The jets are used strictly for business travel. The executives bood reservations thru a centralized transportation office. Because of the limited number of seats available, the planes almost always fly full. Excess demand for seats is assigned by executive rank within the firm. The executive's budget is charged for the flight at the end of the month. The charge is based on the jet's total operating expenses during the month (to include fuel, pilot's salary & fringes, maintenance, licensing & landing fees, and 1/2 of the annual accounting depreciation) divided by the actual passenger miles logged in the month. This rate per passenger is multiplied by each passenger's mileage flown in the month.A. Describe the formula being used to calculate the cost per passenger mile flown.B. As passenger…
Suppose that an organization is engaged in 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. (without using Excel)
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)
Use Excel formulas to complete the calculations and then answer the short-answer questions in the following spreadsheet: Inventory Analysis at Walmart Click for more options Hint: When calculating retail price {RP} based on cost {C} and markup percentage {M%} on RP, use the Cost Complement formula we have discussed previously in class: RP = [(C)/(100% - M%)] x 100
Company XYZ is strictly a service company and does not carry any inventory on its balance sheet. Based on this, which of the ratios below will be of no interest to a financial analyst? Quick Ratio Current Ratio Debt to Equity Ratio Cash Coverage Ratio
What are order cycle costs if annual demand is 10,900 units, the order quantity is 1,800 units, and annual order cost is $140? What if the order size changes to 900 units or 10,900 units? Round your answers to the nearest cent. If the order quantity is 1,800 units, the order cycle costs are $ . If the order quantity is 900 units, the order cycle costs are $ . If the order quantity is 10,900 units, the order cycle costs are $ .
PLEASE ANSWER ASAP, I REALLY NEED HELP
Product Cost under Full vs. Variable Costing Kate’s Kale Chips produces a healthy snackmade primarily of kale. Each bag of the product sells for $5. The company computes the manufacturing overhead rate on a quarterly basis based upon the planned number of units to be produced thatquarter. The following data are from the projections of Kate’s Kale Chips for the upcoming quarter:[LO 18-4]ProjectionsSales 20,000 bagsProduction 22,000 bagsVariable manufacturing cost per bag $2.00Sales and distribution costs per bag $0.15Total fixed manufacturing overhead $33,000Fixed administrative overhead $18,000Required1. Compute the projected product cost per bag produced under full costing.2. Compute the projected product cost per bag under variable costing

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.)