solve all parts within 30 mins Using the gross requirements schedule below*, prepare an alternative ordering system that always orders 100 units the week prior to a shortage (a fixed order quantity of 100). What is the cost ofthis ordering system?Period1 2 3Gross requirements 45 30 50Prepare a net requirements plan (enter your responses as whole numbers).PeriodGross requirementsOn-hand at beginning of period 45On-hand t end of periodNet requirementsOrder receiptOrder release*Holding cost = $1/unit/week; setup cost = $200; lead time = 1 week; beginning inventory = 45 units.The holding cost of this ordering system is $(enter your response as a whole number).The setup cost of this ordering system is $(enter your response as a whole number).The cost of this ordering system is $ (enter your response as a whole number).4 5 6 7 80 10 50 30 01452330 504051010930 55D6750 30809 105530

Answered: Image /qna-images/answer/326b3bc5-b027-4755-8218-b6da861b9f9b.jpg

Answered: solve all parts within 30 mins

Business

Accounting

solve all parts within 30 mins

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 6M

See similar textbooks

Similar questions

8. Day Mail Order Co. applied the high-low method of cost estimation to customer order data for the first four months of 2020. What is the estimated variable order filing cost component per order? Orders 1,200 1,300 1,800 1,700 Costs Р3,120 3,185 January February March 4,320 3,895 April а. Р2.00 b. P2.42 с. Р2.48 d. P2.50 e. None of these; answer is
Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Sales Sale Price 16,400 units 27 Number of Date Beginning March 12 June 5 Units Unit Cost Total Cost 3,500 10.30 $36,050 4,700 10.20 47,940 3,400 10.10 34,340 October 22 8,300 9.90 82,170 Totals 19,900 $200,500 Required: 1. Use your spreadsheet to recalculate the Cost of Goods Sold, Inventory balances, and Gross Profit under each method and enter your results below: (Round your answers to the nearest whole dollar amount.) FIFO LIFO Weighted Average Cost of Goods Sold Ending Inventory Gross Profit
Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Sales Sale Price 9,400 units 27 Date Number of Units Unit Cost Total Cost Beginning 1,500 10.30 $15,450 March 12 2,700 10.20 27,540 June 5 1,400 10.10 14,140 October 22 5,300 9.90 52,470 Totals 10,900 $109,600 Required: 1. Use your spreadsheet to recalculate the Cost of Goods Sold, Inventory balances, and Gross Profit under each method and enter your results below: (Round your answers to the nearest whole dollar amount.). FIFO LIFO Weighted Average Cost of Goods Sold Ending Inventory Gross Profit < Prev ♡ 14 of 14 Next
Dashboard CengageNOWv2 | Onlin X+ 2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker%3D&takeAssignmentSessionLocator=D&inprogress3false Calculator R. & K. Company's beginning inventory and purchases during the fiscal year ended December 31, 20--, were as follows: Units Unit Price Total Cost Jan. 1 Beginning inventory 20 $12 $240 Apr. 2 1st Purchase 30 $13 390 Aug. 6 2nd pPurchase 25 $14 350 Nov. 9 3rd pPurchase 25 $18 450 $1,430 There are 20 units of inventory on hand at December 31, 20--. 1. Calculate the tota! amount to be assigned to the ending inventory under each of the following methods: a. First-in, first-out (FIFO) b. Last-in, first-out (LIFO) 2. Assume the market price per unit (cost to replace) of the R. &. K. Company's inventory on December 31, was $16. Calculate the total amount to be assigned to the ending inventory on December 31, under each of the following methods: a. FIFO lower-of-cost-or-market b. Weighted-average lower-of-cost-or-market All work…
Wincome statement projections ert Design Layout References Mailings Review View Times New R.. 11 - A- A- AaBbCcDdEe AaBbCcDdEe AaBbCcD B U - abe X, x2 A - O A Normal No Spacing Heading 1 To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Company Dhas the following information: Revenue Cost of Goods Sold- Gross Profit- Total operating costs- Operating Income- -150,000,000 -81,825,000 -68,175,000 47,625,000 -20,550,000 Interest Income-- -290,000 -800,000 Interest Expense- Pre-Tax income-- Таx (21%)--- Net Income--- -20,040,000 --4,208,400 -15,831,600 Share outstanding-- Share outstanding for diluted -11,000,000 -12,200,000 Cash- A/R (avg collect Period-30 days) Inventory (Days Inv. Held = 40) Other- Total Current Asset- -11,917,808 --8,967,123 -5,000,000 PP&E--- Less Accumulated Depreciation- Net PP&E- -50,000,000 -10,000,000 -40,000,000 Total current liability 13,842,466 -21,842,466 Total Liabilities--- a. What is the cash amount? b. what is the…
Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Sales Sale Price 22,000 units 27 Date Number of Units Unit Cost Total Cost Beginning 5,100 10.30 $52,530 March 12 6,300 10.20 64,260 June 5 5,000 10.10 50,500 October 22 Totals 10,700 9.90 105,930 27,100 $273,220 Required: 1. Use your spreadsheet to recalculate the Cost of Goods Sold, Inventory balances, and Gross Profit under each method and enter your results below: (Round your answers to the nearest whole dollar amount.) FIFO LIFO Weighted Average Cost of Goods Sold Ending Inventory Gross Profit
03 v2.cengagenow.com/mm/takeAssignment/takeAssignmentMain.do?inprogress=true Classwork 01-03 eBook 2. Prepare a production budget for March. Peaky Blinders Furniture Company Production Budget For the Month Ending March 31 < Line Item Description Thomas Units Polly Units Expected units to be sold Plus desired inventory, March 31 1,000 V 450 Total Less estimated inventory, March 1 Total units to be produced Feedback Check My Work Expected units to be sold plus desired ending inventory minus estimated beginning inventory equals units produced. 3. Prepare a direct materials purchases budget for March. Peaky Blinders Furniture Company Direct Materials Purchases Budget For the Month Ending March 31 Direct Materials: Fabric (sq. yds.) Wood (lineal ft.) Filler (cu. ft.) Springs (units) Total Required units for production: Check My Work Q Search hp 5 16 48 6 & 00 8 U 66 9 3 Previous D prt sc. delete home backspace
Dollar-Value LIFO On January 1, 2018, Sato Company adopted the dollar-value LIFO method of inventory costing. Sato's ending inventory records appear as follows: Year Current Cost Index 2018 $35,100 100 2019 48,900 120 2020 51,480 130 2021 62,580 140 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. X Open spreadsheet Required: Compute the ending inventory for the years 2018, 2019, 2020, and 2021, using the dollar-value LIFO method. Year Ending inventory 2018 35,100 V 2019 %24 2020 2021 %24
Required information Problem 5-1A (Algo) Perpetual: Alternative cost flows LO P1 [The following information applies to the questions displayed below.] Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Date March 1 March 5 March 9 March 18 March 25 March 29 Date March 1 March 5 Complete this question by entering your answers in the tabs below. Total March 5 Perpetual FIFO Perpetual LIFO Weighted Average Specific Id Compute the cost assigned to ending inventory using FIFO. March 9 Problem 5-1A (Algo) Part 3 3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. For specific identification, units sold include 75 units from beginning inventory, 205 units from the March 5 purchase, 55 units from the March 18 purchase, and 95 units from the March 25 purchase. Total March 9 March 18 Total March 18 March 25 Activities Total March 25 Beginning…
* CengageNOWv2 |x C Power Serve Comp. X ilm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentScssionLocator &inprogress=false eBook Calculator Print Item The conderised pruduct-line income statement for Rhinebeck Company for the month of October is as follows: Rhinebeck Company Product-Line Income Statement For the Month Ended October 31 Hats Gloves Mufflers Sales $65,800 $88,500 $27,600 Cost of goods sold (25,800) (32,100) (13,800) Gross profit $40,000 $56,400 $13,800 Selling and administrative expenses (29,000) (34,500) (14,500) $11,000 $21,900 $(700) Operating incorne (loss) Fixed costs are 12% of the cost of goods sold and 36% of the selling and administrative expenses. Rhinebeck Company assunes that fixed costs would not be materially affecter discontinued. a. Prepare a differential analysis dated October 31 to determine if Mufflers should be continued (Alternative 1) or discontiriued (Alternative 2). If an amount is zero, enter "0 indicate a loss. Differential Analysis…
Dollar-Value LIFO On January 1, 2018, Sato Company adopted the dollar-value LIFO method of inventory costing. Sato's ending inventory records appear as follows: Year Current Cost Index 2018 $41,800 100 2019 57,540 120 2020 60,710 130 2021 73,640 140 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Required: Compute the ending inventory for the years 2018, 2019, 2020, and 2021, using the dollar-value LIFO method. Year Ending inventory 2018 41,800 V 2019 69,048 X 2020 60,710 x 2021 $ 73,640 x
File Tools View UTS MK I GSL 20-21 (19.10.20 -13.30) - Word (Product Activation Failed) W UTS MK I GSL 20-21 (19.10.20 -13.30) * x Document2 Problem 1 Balance Shet Income Statement PT. MaTaHtari PT. MATAH+ari For the year Ended December 31 For the year Ended December 31 2019 2018 ASSET Sales Revenue 10.000.000.000 Cash 550.000.000 700.000.000 Cost of Good Sold 6.400.000.000 Marketable Securities 500.000.000 300.000.000 Gross Profit Account Receivable 700.000.000 550.000.000 Inventory 750.000.000 650.000.00D 3.600000.000 Total Currevt Assit 2.500.000.000 2.200.000.000 Operating Expenses Selling Expenses 200.000.000 Gross Fixed Asset 3.000.000.000 General & Administrative Expenses 150.000.000 4.000.000.000 Less : Accumulated Depreciation Depreciation Expenses 250.000.000 500.000.000 200.000.000 Nett Fred Assit Total Operating Expenses 3.500.000.000 2.800.000.000 600.000.000 Operating Profit TOTAL ASSET 6.000.000.000 5.000.000.000 3.000.000.000 Interest Expenses JABILITIBS E STOCKHOLDER'S…