Ram Roy's firm has developed the following supply, demand, cost, and inventory data.Supply AvailableRegularTimeDemandPeriodOvertimeSubcontractForecast130151540230151550330151545Initial inventory20 unitsRegular-time cost per unitOvertime cost per unitSubcontract cost per unitCarrying cost per unit per month$100$160$200$2Assume that the initial inventory has no holding cost in the first period and backorders are not permitted.Allocating production capacity to meet demand at a minimum cost using the transportation method, thetotal cost is $ (enter your response as a whole number).

First arrange the excel sheet with the given data and formula as shown: Now enter the following…

Answered: Ram Roy's firm has developed the…

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

Michael’s Offi ce Supply (MOS) sells offi ce furniture,equipment, and supplies. Th is week the company has received 50customer orders. Each order has an average of fi ve line items. Th eaverage dollar amount of each order is $1200. MOS was able toship 47 of the 50 orders on schedule.(a) Using the percentage of orders shipped on time, calculatethe customer service level.(b) If Michael’s calculates customer service level by using thepercentage of line items shipped on schedule, how manyline items must be shipped to achieve the same customerservice level calculated in part (a)?(c) If Michael’s calculates customer service level by thepercentage of dollar volume shipped, how many dollarsof product must be shipped to achieve the same customerservice level calculated in part (a)?(d) What factors determine the customer service levelmeasure that MOS should use?
Use the table provided below showing rooms available, rooms sold and rooms revenue for 7 properties (subject hotel + comp set) for one month to compute occupancy index for the subject hotel. Rooms Available (Supply) Rooms Sold (Demand) Revenue The subject hotel 10'000 7'000 700'000 Hotel A 9'000 3'000 400'000 Hotel B 9'000 8'000 700'000 Hotel C 10'000 7'000 700'000 Hotel D 000י7 5'000 500'000 Hotel E 11'000 8'000 700'000 Hotel F 8'000 4'000 400'000
The annual demand for an automobile part is 3200 units. The unit cost is 60 OMR and inventory carrying charge is 25% of unit cost. Ordering cost is 20 OMR per order. (i) Determine the economic order point (ii) If you place an order for 110 units every time, is it profit or loss? How much and Why? (iii) Why demand forecasting is important for an organization? Compare qualitative and quantitative forecasting technique with an example.
Use the table provided below showing rooms available, rooms sold and rooms revenue for 7 properties (subject hotel + comp set) for one month to compute occupancy index for the subject hotel. ITI Rooms Available (Supply) Rooms Sold (Demand) Revenue The subject hotel 10'000 7'000 700'000 Hotel A 9'000 3'000 400'000 Hotel B 9'000 8'000 700'000 Hotel C 10'000 7'000 700'000 Hotel D 7'000 5'000 500'000 Hotel E 11'000 8'000 700'000 Hotel F 8'000 4'000 400'000 Select one: a. None of the above b. 106.67 c. 108.00 / d. 92.59
Average order fulfillment cycle time would be an example of a SCOR model metric for which performance attribute? A. Supply chain costs B. Supply chain responsiveness C. Supply chain reliability D. Supply chain agility
9 Cindy’s favorite product in the store is the carrot cookie. Healthy Goods started selling carrot cookies just a few months ago, and they have not kept track of the sell out data. Cindy has been chatting with a few of the cashiers to get a sense of the overall demand for carrot cookies. The cashiers told her the store usually sells around 100 carrot cookies per week, although during the best selling week they can recall 204 carrot cookies were sold, and during a bad week only 49 cookies were sold. If they plan to have 85 cookies in inventory every week, what would be the probability of not fulfilling all the weekly demand?
Thinking tools service assembles customized personal computers from generic parts. Formed and operated by part-time Svci students paulette cruz and maureen luis, the company has had steady growth since it started. The company assembles computers mostly at night, using part time students. Paulette and Maureen purchase generic computer parts in volume at a discount from a variety of sources whenever they see a good deal. Thus, they need a good forecast of demand for their computers so that they will know how many parts to purchase and stock. They have compiled demand data for the last 12 months as reported below A. Use exponential smoothing with smoothing parameter a=0.2 to compute the demand forecast for january (period 13) B. Use exponential smoothing with smoothing parameter a=0.5 to compute the demand forecast for january (period 13). C. Paulette believes that there is an upward trend in the demand, the initial forecast is 37 and the trend over this period is 0 units. Use…
can you please help me answer this question.... Rebar Company prepared the following analysis of its year-end inventory on December 31. First, determine the total lower of cost or market value for each product in Rebar Company's inventory. Second, prepare the journal entry needed at year-end to value the inventory at LCM, if applicable. Historical Cost Replacement Cost Product Quantity per unit per unit A 17 $430 $499 B 140 325 299 C 38 75 69
1. With examples and necessary figures, define the Key Inventory Terms ? 2. Suppose, you are newly appointed as a Sales Manager in Unilever Company and after joining your first assignment is to do the sales forecast for the next quarter. Therefore, explain what would be your approach to do a good sales forecast for the next quarter.
How might different organizational functions havedifferent inventory management objectives?
Define the term Independent Demand and explain how it relates to the salesand marketing activity of firms. Explain the benefits of accurate estimationof future Demand within the context generating a reliable production plan
How does the Wilson approach adapt to seasonal variations in demand and inventory management?

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