Compute december sales and cost of goods sold

Assignment Help Financial Accounting
Reference no: EM13183430

You have just landed at temporary assignment at a small retail company in your area. The accountant, who had completed the books through the end of November, went out on maternity leave during the first week of December. The task you have been given is to take the ending Trial Balance for November, prepare December transactions, prepare the December financials, and close the books.

The manager of the company has indicated that salaries and rent for December are the same as the 11 months preceding (employees are paid at the end of the month). Additional transaction information follows:

December Advertising = $900 December Utilities = $700
December Communications = $500

The manager is pretty sure that they use LIFO for inventory, but it could be FIFO. Given the November transactions, determine which of the two methods is used. Then, use that same method to value ending inventory for December. Compute December Sales and Cost of Goods Sold, as well, and prepare the journal entries. Assume 80% of Sales are credit sales and the rest are for cash.

November


December

11 - 01 begin with 500 units @ $22.00 each 12 - 01 begin with 1,350 units @ $36,000
11 - 03 sold 250 units @ $35.00 each
12 - 04 sold 350 units @ $38.00 each
11 - 05 purch 500 units @ $23.00 each
12 - 10 purch 500 units @ $29.00 each
11 - 10 sold 250 units @ $36.00 each
12 - 13 sold 600 units @ $40.00 each
11 - 15 purch 450 units @ $26.00 each
12 - 18 purch 600 units @ $31.00 each
11 - 19 purch 300 units @ $28.00 each
12 - 20 sold 600 units @ $41.00 each
11 - 23 sold 200 units @ $37.00 each
12 - 21 purch 400 units @ $30.00 each
11 - 29 purch 300 units @ $30.00 each
12 - 24 sold 550 units @ $42.00 each

During December, supplies purchased totaled $1,100. A physical count showed that there were $1,850 remaining at the end of the year. Prepare the necessary adjusting entry.

It was discovered that the insurance policy was renewed on December 1st; coverage will cost $6,720 for the next 12 months. Prepare the necessary entries.

Collected $18,500 in cash from previous sales on credit. Those customers received $350.00 in discounts.
Attachment:- Project.xls

Reference no: EM13183430

Questions Cloud

Compute the molar heat of solution of kcn : the temperature decreases by 0.2010 K. Calculate the molar heat of solution of KCN.
Prepare frame-it''s budgeted income statement : Prepare Frame-It Company's master budget for 20x1 by completing the following schedules and statements - prepare Frame-It's budgeted income statement
How costless bargain will lead to socially efficient outcome : A firm can produce steel with or without a filter on its smokestack. If it produces without a filter, the external costs on the community are $500,000 per year. If it produces with a filter, there are no external costs on the community, and the fi..
Define bakelite us obtained by the condensation : 1) Bakelite us obtained by the condensation of : 2) When HCHO reacts with Nh3, the compound formed is :
Compute december sales and cost of goods sold : It was discovered that the insurance policy was renewed on December 1st; coverage will cost $6,720 for the next 12 months. Prepare the necessary entries.
How many firms will be operating in the equilibrium : How much is the long-run equilibrium price? How many firms will be operating in this equilibrium? Plot two side-by-side graphs to illustrate the long-run equilibrium; one should show a typical firm in equilibiurm, the other should show the market..
What is the average variable cost-avc as a function : John's Lawn Mowing Service is a small business that acts as a price taker. John's short-run total cost is given by STC = 0.1q2 + 10q + 50, where q is the number of acres John chooses to cut a day. Total fixed cost is TFC = 50 and total variable co..
State what is defined as the number of atoms surrounding : What is defined as the number of atoms surrounding an atom in a crystal lattice and indicate how tightly the atoms
Estimate for the true daily weight gain : Agri-Beef Inc. operates cattle feed lots in several midwestern states. The company wishes to estimate the average daily weight gain of cattle on their lots. To do this a simple random sample of cattle is taken and the daily weight gain is recorde..

Reviews

Write a Review

Financial Accounting Questions & Answers

  What federal taxable income in determining

the state regular-tax basis in the asset was $60,000. What adjustment, if any, should be made to Federal taxable income in determining the correct state taxable income for the typical state?

  Calculation of estimated allowance for doubtful accounts

Calculation of Estimated Allowance for doubtful accounts with a change in Sales - What would you answers be for parts 1 and 2 if sales for the current period were $220,000

  How much would you have at the end of that time

how much would you have at the end of that time, assuming that your account earns 5% interest compounded daily? Assume also that you drink a cup of coffee every day, including weekends.

  What is meant by forensic-type fieldwork phase of an audit

What is meant by the forensic-type fieldwork phase of an audit? An AICPA Fraud Task Force suggests that if a forensic accountant is brought into an audit to conduct a separate investigation (and not an adjunct to an audit), what standards apply?

  Complete cvp income statement for the quarter ended march

Bruno Manufacturing Inc. has sales of $2,371,200 for the first quarter of 2010. In making the sales, the company incurred the following costs and expenses. Complete CVP income statement for the quarter ended March 31, 2010.

  Journal entries required to create and close the warranty

Make the Journal entries required to create and close the warranty period

  Ow much money should be set aside at end of each month

A supplemental retirement fund of $200,000 is desired in 20 years. How much money should be set aside at the end of each month if the interest rate is 1% per month.

  Leadership and provide a synopsis of each company

Analyze each company's history, product / services, major customers, major suppliers, and leadership and provide a synopsis of each company.

  At what level of l does diminishing returns set in

At what level of L does diminishing returns set in? At what level of L does the marginal product equal the average product?

  Compute palms taxable income

Palm received $25,000 of prepaid rent not included in book income. Based only on these items, compute Palm's taxable income.

  Evaluate the kennaman''s net operating income

Decision on closure of one of the units with the help of decrease in net income -  Evaluate the overall increase or decrease in Kennaman's net operating income if Store I is closed.

  Complete the statements and schedules for the first quarter

Using the data complete the statements and schedules for the first quarter

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd