Question

In: Accounting

On March 31 a company needed to estimate its ending inventory to prepare its first quarter...

On March 31 a company needed to estimate its ending inventory to prepare its first quarter financial statements. The following information is available: Beginning inventory, January 1: $5,900 Net sales: $88,000 Net purchases: $86,000 The company's gross margin ratio is 20%. Using the gross profit method, the estimated ending inventory value would be:

Solutions

Expert Solution

Working Notes:
Caclulation of cost of Goods Sold as per gross profit method
Amount in $  
Net Sales = $                    88,000
Less: Gross Profit (20% of $ 88,000) $                    17,600
Equals to = Cost of Goods Sold = $                    70,400
Solution:
Calculation of Ending Inventory
Particulars Amount in $  
Beginning balance of invenotry = $                       5,900
Add : Net Purchases made $                    86,000
Total Goods Available for sale (A) $                    91,900
Less: Cost of Good Sold (B) $                    70,400
Equals to = Estimated Ending inventory (A-B) $                    21,500
Answer = Estimated Ending inventory = $ 21,500

Related Solutions

The Hammerly Corporation is preparing its master budget for the quarter ending March 31. It sells...
The Hammerly Corporation is preparing its master budget for the quarter ending March 31. It sells a single product for $25 a unit. Budgeted sales are 40% cash and 60% on credit. All credit sales are collected in the month following the sales. Budgeted unit sales as provided by Regional Vice Presidents of Sales across the United States for the next four months follow: Key Facts January February March April Sales in units ………………. 1,200 1,000 1,600 1,400 At December...
   . Prepare a cash budget for January through March and for the first quarter in...
   . Prepare a cash budget for January through March and for the first quarter in total. The company maintains a minimum cash balance of $70,000, and this was the balance in the cash account on January 1st. Other expenses include $35,000 per month for rent, $24,000 per month for advertising, and $66,000 per month for depreciation. In addition, variable Selling & Administrative cost is $12 per unit sold, and the company paid a $20,000 dividend in February. The company...
Montevideo Company had the following account balances for the quarter ending March 31, unless otherwise noted:...
Montevideo Company had the following account balances for the quarter ending March 31, unless otherwise noted: Work-in-process inventory (January 1) $ 140,400 Work-in-process inventory (March 31) 171,000 Finished goods inventory (January 1) 540,000 Finished goods inventory (March 31) 510,000 Direct materials used 378,000 Indirect materials used 84,000 Direct manufacturing labor 480,000 Indirect manufacturing labor 186,000 Property taxes on manufacturing plant building 28,800 Salespersons' company vehicle costs 12,000 Depreciation of manufacturing equipment 264,000 Depreciation of office equipment 123,600 Miscellaneous plant overhead...
Messinger Manufacturing Company had the following account balances for the quarter ending March 31, unless otherwise...
Messinger Manufacturing Company had the following account balances for the quarter ending March 31, unless otherwise noted: Work-in-process inventory (January 1) $ 140,400 Work-in-process inventory (March 31) 171,000 Finished goods inventory (January 1) 540,000 Finished goods inventory (March 31) 510,000 Direct materials used 378,000 Indirect materials used 84,000 Direct manufacturing labor 480,000 Indirect manufacturing labor 186,000 Property taxes on manufacturing plant building 28,800 Salespersons' company vehicle costs 12,000 Depreciation of manufacturing equipment 264,000 Depreciation of office equipment 123,600 Miscellaneous plant...
Messinger Manufacturing Company had the following account balances for the quarter ending March 31, unless otherwise...
Messinger Manufacturing Company had the following account balances for the quarter ending March 31, unless otherwise noted: ​Work-in-process inventory (January 1)​$140,400 ​Work-in-process inventory (March 31)​171,000 ​Finished goods inventory (January 1)​540,000 ​Finished goods inventory (March 31)​510,000 ​Direct materials used​378,000 ​Indirect materials used​84,000 ​Direct manufacturing labour​480,000 ​Indirect manufacturing labour​186,000 ​Property taxes on manufacturing plant building​28,800 ​Salespersons' company vehicle costs​12,000 ​Amortization of manufacturing equipment​264,000 ​Amortization of office equipment​123,600 ​Miscellaneous plant overhead​135,000 ​Plant utilities​92,400 ​General office expenses​305,400 ​Marketing distribution costs​30,000 Required: a.​Prepare a cost...
Messinger Manufacturing Company had the following account balances for the quarter ending March 31, unless otherwise...
Messinger Manufacturing Company had the following account balances for the quarter ending March 31, unless otherwise noted: Accounts Amount Work-in-process inventory (January 1) $ 140,400 Work-in-process inventory (March 31) 171,000 Finished goods inventory (January 1) 540,000 Finished goods inventory (March 31) 510,000 Direct materials used 378,000 Indirect materials used 84,000 Direct manufacturing labor 480,000 Indirect manufacturing labor 186,000 Property taxes on manufacturing plant building 28,800 Salespersons' company vehicle costs 12,000 Depreciation of manufacturing equipment 264,000 Depreciation of office equipment 123,600...
The XYZ Company uses the conventional retail inventory method to estimate ending inventory for its monthly...
The XYZ Company uses the conventional retail inventory method to estimate ending inventory for its monthly financial statements and presents the following data for one department for February 2020. Present a schedule that shows the ending inventory at cost and highlight that cell with color and a thick outside border. Label each column and row clearly so your workpaper can be used by other people in Marquette's accounting department. Present the cost to retail percentage as a percentage with two...
Evergreen Corporation is preparing the master budget for the third quarter ending March 31, 2009.  It sells...
Evergreen Corporation is preparing the master budget for the third quarter ending March 31, 2009.  It sells a single product for $20 a unit.  Sales are 25% cash and 75% credit.  The credit sales are collected 30% in the month of the sale and the remaining 70% is collected in the next month.  No credit sales occurred in December 2008. The December 31 inventory of finished goods is 15,000 units and projected sales are 20,000, 55000, 65,000, 75,000, and 85,000 units for the first  months...
Evergreen Corporation is preparing the master budget for the third quarter ending March 31, 2009.  It sells...
Evergreen Corporation is preparing the master budget for the third quarter ending March 31, 2009.  It sells a single product for $20 a unit.  Sales are 25% cash and 75% credit.  The credit sales are collected 30% in the month of the sale and the remaining 70% is collected in the next month.  No credit sales occurred in December 2008. The December 31 inventory of finished goods is 15,000 units and projected sales are 20,000, 55000, 65,000, 75,000, and 85,000 units for the first  months...
Evergreen Corporation is preparing the master budget for the third quarter ending March 31, 2009.  It sells...
Evergreen Corporation is preparing the master budget for the third quarter ending March 31, 2009.  It sells a single product for $20 a unit.  Sales are 25% cash and 75% credit.  The credit sales are collected 30% in the month of the sale and the remaining 70% is collected in the next month.  No credit sales occurred in December 2008. The December 31 inventory of finished goods is 15,000 units and projected sales are 20,000, 55000, 65,000, 75,000, and 85,000 units for the first  months...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT