Cost of Goods Sold $10,000,000 FIGURE 12.5 Calculating Inventory Measures Using Inventory Weeks of Operation 52 Item Number Average Level 1,400 Unit Value Estimator Solver Raw Materials Total Value $70,000 1 $50.00 2 1,000 $32.00 $32,000 3 400 $60.00 $10.00 $24,000 $24,000 4 2,400 $12,000 $224,000 800 Work in Process $15.00 $700.00 320 7 160 $900.00 $144,000 $210,000 $192,000 280 $750.00 $800.00 8 9 240 400 $1,000.00 $2,000.00 $400,000 $120,000 10 Finished Goods 11 60 12 40 $3,500.00 $140,000 13 50 $2,800.0 $5,000.00 $140,000 $100,000 14 20 40 $4,200.00 $168,000 $2,000,000 15 Total Average Weekly Sales at Cost $192,308 Weeks of Supply 10.4 Inventory Turnover 5.0

Cost of Goods Sold $10,000,000 FIGURE 12.5 Calculating Inventory Measures Using Inventory Weeks of Operation 52 Item Number Average Level 1,400 Unit Value Estimator Solver Raw Materials Total Value $70,000 1 $50.00 2 1,000 $32.00 $32,000 3 400 $60.00 $10.00 $24,000 $24,000 4 2,400 $12,000 $224,000 800 Work in Process $15.00 $700.00 320 7 160 $900.00 $144,000 $210,000 $192,000 280 $750.00 $800.00 8 9 240 400 $1,000.00 $2,000.00 $400,000 $120,000 10 Finished Goods 11 60 12 40 $3,500.00 $140,000 13 50 $2,800.0 $5,000.00 $140,000 $100,000 14 20 40 $4,200.00 $168,000 $2,000,000 15 Total Average Weekly Sales at Cost $192,308 Weeks of Supply 10.4 Inventory Turnover 5.0

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Production and Materials Purchases Budgets White Corporation’s budget calls for the following sales for next year:Quarter 1 90,000 units Quarter 3 68,000 unitsQuarter 2 76,000 units Quarter 4 96,000 unitsEach unit of the product requires 3 pounds of direct materials. The company’s policy is to begineach quarter with an inventory of product equal to 5% of that quarter’s estimated sales requirementsand an inventory of direct materials equal to 20% of that quarter’s estimated direct materials requirements for production.Required Determine the production and materials purchases budgets for the second quarter.
Information on a business is given below.Variable Expenses:Raw material expense: 250 TL / pieceAuxiliary equipment expense: 150 TL / pieceElectricity expenses: 100 TL / pieceSpare parts expense: 75 TL / pieceOther variable expenses: 125 TL / pieceFixed costs:Depreciation, interest and insurance expenses: 75 000 TLLabor and personnel expenses: 250 000 TLOther fixed expenses: 115 000 TLProduction capacity: 2000 pcs / monthSale price: 1600 TL / pieceAccording to the above,a) Find the break-even point as the production quantity?b) Find the amount that the business has to produce in order to make a profit of 500 000 TL / month?
Prior to opening his branch in Fourways, Conrad made a decision to conduct further research intopotential suppliers for his new business venture. He downloaded the integrated annual report forAstral Foods to conduct his research. The link for the integrated annual report can be found using thefollowing link:https://www.astralfoods.com/assets/Documents/Investor%20Centre/2022/Integrated%20Report%20for%20the%20year%20ended%2030%20September%202022.pdf. Q3.2 Discuss the viewpoint you believe Chicky Fillet should adopt towards stakeholders.Discuss the various stakeholders, their possible interests, and the proposed businessapproach towards honouring their interests.
Suppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017. (in millions) 2015 2016 2017 Beginning inventory $ 2,100 $ 2,400 $ 2,300 Ending inventory 2,400 2,300 2,700 Cost of goods sold 18,227 20,071 20,478 Sales revenue 39,145 42,957 44,066 Calculate the days in inventory for PepsiCo, Inc. for 2015, 2016, and 2017. (Round days in inventory to 1 decimal place, e.g. 5.1.) 2015 2016 2017 Days in inventory days
Omega DB Corp. has a policy of maintaining an inventory of finished goods equal to 40 percent of the next month’s budgeted sales. If Omega DB Corp. plans to produce 6,000 units in June, what are budgeted sales for July in units? Budgeted sales for the first six months of 2019 for Omega DB Corp. are listed below: Units:JANUARY 6,000FEBRUARY 7,000MARCH 8,000APRIL 7,000MAY 5,000JUNE 4,000
M&L Manufacturing makes various components for printers andcopiers. In addition to supplying these items to a major manufacturer,the company distributes these and similar items to officesupply stores and computer stores as replacement parts forprinters and desktop copiers. In all, the company makes about20 different items. The two markets (the major manufacturerand the replacement market) require somewhat different handling.For example, replacement products must be packagedindividually whereas products are shipped in bulk to the majormanufacturer.The company does not use forecasts for production planning.Instead, the operations manager decides which items to produceand the batch size, based on orders and the amounts in inventory.The products that have the fewest amounts in inventory get thehighest priority. Demand is uneven, and the company has experiencedbeing overstocked on some items and out of others. Beingunderstocked has occasionally created tensions with the managersof…
M&L Manufacturing makes various components for printers andcopiers. In addition to supplying these items to a major manufacturer,the company distributes these and similar items to officesupply stores and computer stores as replacement parts forprinters and desktop copiers. In all, the company makes about20 different items. The two markets (the major manufacturerand the replacement market) require somewhat different handling.For example, replacement products must be packagedindividually whereas products are shipped in bulk to the majormanufacturer.The company does not use forecasts for production planning.Instead, the operations manager decides which items to produceand the batch size, based on orders and the amounts in inventory.The products that have the fewest amounts in inventory get thehighest priority. Demand is uneven, and the company has experiencedbeing overstocked on some items and out of others. Beingunderstocked has occasionally created tensions with the managersof…
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. * a. 75 b. 480 c. 500 d. 20 2. The amount of your product that you will need to produce and sell to cover total costs of production. * a. Break even sales volume b. Sales volume percentage c. Sales volume
The following data is extracted from the books of Gulf company, Fixed cost OMR 12.000. Selling price OMR.8 per unit and variable cost OMR 2 per unit. How many units will be sold in excess of the breakeven point if Gulf Company wishes to make a profit of OMR 6.000 ? a. 1,000 units b. 2,000 units C. 1.500 units d. 3.000 units
1) What is the total demand of an enterprise with an economic order quantity of 1,500 units, a cost of 11.250 TL for each order, and 75 TL for one unit of inventory?a) 20,000b) 17,500c) 7,500d) 12,500f) 2,500 2) What is the total inventory cost of this business?a) 200,000b) 239,000c) 185,250d) 168,750e) 218,500
Determine the board measure (BF) and the cost 2x4 = $1700 MBM MBM or FBM = Thousand Board Measure or Thousand Board Feet 2 x 6 = $1600 MBM 2x10 = $ 1900 MBM 3/8 OSB = $ 1700 7/16 OSB = $ 1750 All prices are given is per Thousand Square Feet 3/4 OSB = $ 2400 1) 250 pcs of 2x4 …. 10 feet long 2) 300 pcs of 2x6 …. 4 meters long 3) 45 pcs of 2x10 …. 16 foot long
Grey Manufacturing Company expects sales to total 13,000 units in the first quarter, 12,000 units inthe second quarter, and 15,000 units in the third quarter of the current fiscal year. Company policyis to have on hand at the end of each quarter an amount of inventory equal to 10% of the followingquarter’s sales. Given this information, how many units should be scheduled for production in thesecond quarter?