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

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Hello! Please help me fill in the blanks in the last empty chart and answer question number 3 at the very end in bold. Thank you! :) UnitsProduced TotalLumberCost TotalUtilitiesCost Total MachineDepreciationCost 7,000 shelves $70,000 $9,550 $135,000 14,000 shelves 140,000 17,600 135,000 28,000 shelves 280,000 33,700 135,000 35,000 shelves 350,000 41,750 135,000 Cost Fixed Portionof Cost Variable Portionof Cost (per Unit) Lumber 0 10 Utilities 1,500 1.15 Depreciation 135,000 0 Question Content Area Units Produced Total Cost January 4,360 units $65,600 February 275 6,250 March 1,000 15,000 April 6,775 136,250 May 1,750 32,500 June 3,015 48,000 1. From the data previously provided, help Biblio Files Company estimate the fixed and variable portions of its total costs using the high-low method. Recall that Total Costs = (Variable Cost Per Unit x Number of Units Produced) + Fixed Cost.…
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
Please help me with correct answer thanku
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
sd subject-Accounting
Hi I need help
please answer correct and complete with full working like explanation , computation , formulation answer in text will surely upvote if complete and correct with working please no copy paste from other answer attempt if sure otherwise skip need correct and complete answer thanks answer in text
Clas Cop Hig Hig Cer Bra Sca Shopping No Sac lov engagenow.com/ilm/takeAssignment/takeAssignmentMain.do?inprogress=true C 中 eBook Instructions: 1. Determine the estimated units of sales of the overall product necessary to reach the break-even point for the current year. 2,320 units 2. Based on the break-even sales (units) in part (1), determine the unit sales of both Kayaks and Canoes for the current year. Kayaks Canoes units 928 1,392 units 3. Assume that the sales mix was 60% Kayaks and 40% Canoes. Determine the estimated units of sales of the overall product necessary to re break-even point for the current year. units 4. Based upon the break-even sales (units) in part (3), determine the unit sales of Kayaks and Canoes for the current year. Kayaks Canoes units units 5. The overall enterprise break-even point increased lower ✓ contribution margin per unit of product. Feedback from (1) to (3) because the sales mix is weighted more toward the product with the Check My Work 1-3. Subtract…
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
Do not give answer in image
On the Data Tables - Student tab in your Excel spreadsheet, update the given information section of the Income Statement for Hello Company with the data below: Income Statement Product A Product B Product C Max Capacity Units 42,000 7,000 3,000 52,000 Price per unit $ 11.00 $ 8.00 $ 60.00 Variable expense per unit $ 4.00 $ 2.00 $ 20.00 Total Fixed Costs $ 20,000 $ 40,000 $ 10,000 Required: 2. Using the Data Table What-If Analysis tool in Excel, determine the Units and Operating Income (Loss) for each product based on the following scenarios. (Hint: Don't forget that the warehouse can only hold up to 52,000 units.) Scenario 1: Pete wants to find the mix of units that will result in the highest overall Operating Income, perform this analysis using a two variable data table. Product A can vary between 39,000 units and a maximum of 44,000 units. Product B can vary between 5,000 units…