Revise your worksheet to reflect these updated assumptions and then answer the questions that follow.SalesSale Price9,400 units27DateNumber of UnitsUnit CostTotal CostBeginning1,50010.30$15,450March 122,70010.2027,540June 51,40010.1014,140October 225,3009.9052,470Totals10,900$109,600Required:1. Use your spreadsheet to recalculate the Cost of Goods Sold, Inventory balances, and Gross Profit under each method and enteryour results below: (Round your answers to the nearest whole dollar amount.).FIFOLIFOWeightedAverageCost of Goods SoldEnding InventoryGross Profit< Prev♡14of 14Next

The inventory is a part of the working capital, the entity holds inventory to sell and make revenue.…

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 Totals 10,900 52,470 $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

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 Totals 10,900 52,470 $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

Quickbooks Online Accounting

3rd Edition

ISBN:9780357391693

Author:Owen

Publisher:Owen

Chapter5: Operating Activities: Purchases And Cash Payments

Section: Chapter Questions

Problem 2.7C

See similar textbooks

Similar questions

Calculate the missing information. Round dollars to the nearest cent and percents to the nearest tenth of a percent. Item Cost Amount ofMarkup Selling Price (in $) PercentMarkupBased onCost PercentMarkupBased onSelling Price Bar of soap $1.16 $0.79 $ % %
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
Calculate total revenue and fill in the table below. Price Quantity Total Revenue S50 60 $40 06 $35 110 S30 140 $25 190
The following information is given for Gator Company, who uses the FIFO method. Item Quantity Cost NetRealizableValue ReplacementCost NRVMinusNormalProfit 1 1 $17.70 $24.60 $18.00 $17.10 2 1 10.80 8.28 9.30 5.58 3 1 72.00 64.80 67.20 57.60 4 1 4.80 3.12 2.88 2.64 5 1 12.00 12.30 12.60 11.10 6 1 48.00 45.60 38.40 40.80 Required: a. Determine the lower of cost or net realizable value for each inventory item for Gator Company. Item 1 2 3 4 5 6 b. Determine the lower of cost or net realizable value for Gator Company's inventory if the lower of cost or net realizable value rule is applied to the total inventory.$_______
The following information is given for Gator Company, who uses the FIFO method. Item Quantity Cost NetRealizableValue ReplacementCost NRVMinusNormalProfit 1 1 $17.70 $24.60 $18.00 $17.10 2 1 10.80 8.28 9.30 5.58 3 1 72.00 64.80 67.20 57.60 4 1 4.80 3.12 2.88 2.64 5 1 12.00 12.30 12.60 11.10 6 1 48.00 45.60 38.40 40.80 Required: a. Determine the lower of cost or net realizable value for each inventory item for Gator Company. Item 1 $fill in the blank 1 2 $fill in the blank 2 3 $fill in the blank 3 4 $fill in the blank 4 5 $fill in the blank 5 6 $fill in the blank 6 b. Determine the lower of cost or net realizable value for Gator Company's inventory if the lower of cost or net realizable value rule is applied to the total inventory. $fill in the blank 7
Refer to the pictur ebelow: Find: 1. Total Cost of Product A under ABC System2. Total Cost of Product B under ABC System3. Selling Price per unit of Product B assuming profit margin of 20% above cost
Activity 2: Complete me! Directions: Fill in the needed data to complete the table below. Unit B.E.P in B.E.P in Selling Price per Unit Variable Cost per Unit Total Fixed Cost Contributio Units Pesos n Margin P19,500.00 P15.00 P13.00 P960.00 P18.00 P15.00 P24.00 P3.00 69 P34.00 P3.00 150 P27.00 P5.00 100 2. 3. 4.
Using the decision-making grid below, calculate the total score for Appliance "A." Appliance A Criteria Decision Weight (W) Score (S) WxS Price 30% 6 Durability 25% 8 Features 20% 8 Warranty 15% 7 Styling 10% 9 TOTAL 100%
An analyst has started preparing a spreadsheet as shown below. Column A contains the headings for various parameters and Column B contains the analyst's range names to be used in Excel. A 1 Price per Unit 2 Cost per Unit 3 Profit per Unit Price_per_Unit Cost per Unit Profit$_per_Unit 4. 5 Fixed Costs 6 Variable Costs Fixed Costs VariableCosts Label each of the following range names as "Correct" if is a valid range name in Excel or "Incorrect" if the range name is not valid for use in Excel. Proposed Range Name Price_per_Unit Cost per Unit Profit$_per_Unit Fixed Costs VariableCosts
Assume that markup is based on cost. Calculate the cost and selling price. Note: Round your answers to the nearest cent. Cost Selling price Dollar markup $ 6.00 Percent markup on cost 101.69 %
Assume that Demand (D) = 10,000 units and Ordering Cost (S) = $10 (per order). Suppose that we order at the Economic Order Quantity (EOQ) and the total inventory cost TC $500. What is the EOQ?
Requirement 1. Calculate the EOQ. Begin by selecting the formula used to calculate EOQ. (D=Demand in units for one year, P=Ordering cost per purchase order, C=Carrying cost of one unit in stock, Q=Any order quantity.) ModifyingAbove EOQ equals StartRoot StartFraction 2 DP Over Upper C EndFraction EndRoot With Subscript EOQ=2DPC Part 2 (Round your answer to the nearest whole number.) The EOQ is 560 jerseys. Part 3 Requirement 2. Calculate the number of orders that will be placed each year. Determine the formula used to calculate the number of orders that will be placed each year, then calculate the orders per year. (Round your answer up to the nearest whole number.) ÷ = Number of orders