Josie Gall's firm has developed the supply, demand, cost, and inventory data that follow.Supply AvailablePeriod123RegularTime403540Overtime151515Subcontract101010DemandForecast30 units$100$150$200$6506555Initial inventoryRegular-time cost per unitOvertime cost per unitSubcontract cost per unitCarrying cost per unit per monthAssume 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, the total cost is(Enter your response as a whole number.)

The given problem is for Aggregate planning. It has been specified to use the transportation method…

Answered: Josie Gall'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

Camille forecasts to sell 575 units of the perfume she is selling by the first week of December. At the end of the 1st week of December, she was able to disposed 500 perfumes at Php150 each. Of these 500 units, she gave a total of 20 giveaways. The total cost for each perfume is Php120. Determine Camille’s net sales volume. *4802075500 Let’s say that last November you have sold 10,000 pieces of chrysanthemum at 25 pesos each. For every piece sold, you will be given a commission of 10%. How much was your total commission? *225,00025,00010,0002.50250,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.
Construct the cost living index number by (i) Aggregative expenditure method. (ii) Family budget method for the year 2004 taking 200 as base. Commodity Quantity Unit price($) 2000 2004 |2 Qnts Qnt 25 kg Qnt 10 kg kg kg 25kg Clothing 25 met Meter 4 Qnts Qntl |House woeat 50 75 Rice 100 120 Sugar Pure Ghee5 kg Veg. Ghee 5kg Qnt 80 120 10 10 Oil Qnt 200 200 4 Fuel 8 10 Rent |One 20 25
A firm is faced with the attractive situation in which it canobtain immediate delivery of an item it stocks for retailsale. The firm has therefore not bothered to order the item in any systematic way. However, recently profits have beensqueezed due to increasing competitive pressures, and thefirm has retained a management consultant to study itsinventory management. The consultant has determined thatthe various costs associated with making an order for theitem stocked are approximately $70 per order. She has alsodetermined that the costs of carrying the item in inventoryamount to approximately $27 per unit per year (primarilydirect storage costs and forgone profit on investment ininventory). Demand for the item is reasonably constantover time, and the forecast is for 16,500 units per year.When an order is placed for the item, the entire order isimmediately delivered to the firm by the supplier. The firm operates 6 days a week plus a few Sundays, or approxi-mately 320 days per year.…
Assume the weight is 0.6 for the most recent period; 0.2 for the second most recent; 0.1 for the third most recent; and 0.1 for the fourth most recent period. Using the four-period weighted moving average technique to predict the demand in February 2019. Find the X and Y values. Dt Ft Period Demand Four-period weighted Moving Average 2014 September 9400 October 10300 November 11200 December 4998 2015 January 9800 7209 February 9555 X March 9800 Y Group of answer choices X = 9899.8; Y = 9778.2 X = 9312.8; Y = 9555.2 X = 9029.6; Y = 9312.8 X = 9555.0; Y = 9313.7 X = 9872.4; Y = 9029.4
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
Jane Nursery grows pink and peach roses in her 100 by100 foot garden. She then sells it at the local farmers'market. Two month ago, she was able to produce andsell 12,000 buds of roses. Last month, she tried a newfertilizer that promised a 50% increase in yield. Sheharvested 1,980 buds of roses. Did the fertilizer live up toits promise?
In determining open-to-buy, what is subtracted from planned purchases? O On hand On order EOM stock BOM stock Question 37 Your department is planning a 10 percent increase in sales for the entire three- month period (February-April). Sales for the period last year were $19,000. Fifty percent of the total planned sales are projected to occur in March, and 25 percent of sales are planned to occur in each of the other two months. Planned stock-sales ratio for each month is 2.0. Total planned reductions for the period are 5 percent of planned sales. Reductions are projected to occur for each month as follows: February (10 percent), March (40 percent), and April (50 percent). An ending inventory of $5,000 is planned for the period. PLANNED PURCHASES FOR FEBRUARY ARE: O $24,200 O $15.779 O None (overbought). $10.895.50
Knowing how to use the ABC analysis, make up a list of 10 items in a stores inventory, then decide which 10 items sold at the store would constitute 80% of the revenue and create a Word document using the ABC analysis.
Add two (2) new customers, two (2) old customers and two (2) new POS transactions. SalesID InvoiceNo TransDate Item Description Color Size qty Price StoreID YearID Brand Name Address CurrID YEARVAL 82605 10828 06-Dec-09 8720400000227 REGULAR CIGARS 1 21.74 TCS 2009 HENRI WINTERMANS Yetty BDS 2009 47075 45036325 26-Aug-08 POSTCARDS POSTCARDS 1 1.4 CS 2008 Guenna BDS 2008 4590 60007295 14-Jan-08 3707-11-6 BLOUSES BLK/MLT L 1 586 CC 2008 GOTTEX Yankee CORAL REEF HOTEL USD 2008 4599 60007301 15/1/2008 3007-319-18 PANTS CORAL XS 1 200 CC 2008 CUT LOOSE Quigly YEARWOOD RD BLK ROCK USD 2008
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?

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