The Dawson Company has just completed a number of budgets for the coming year. The cost of goods manufactured schedule, the pro forma income statement, and the balance sheet still have to be completed. The following information is available as 12/31/X8. Prior Year Balance Sheet Assets   Cash $45,000 Accounts Receivable $55,000 Materials Inventory $40,000 Work-in-Process Inventory $30,000 Finished Goods Inventory $36,000 Prepaid Expenses $20,000 Plant and Equipment $500,000 Accumulated Depreciation ($140,000) Other Assets $22,000 Total Assets $608,000 Liabilities and Equity  Accounts Payable $103,000  Other Current Liabilities $42,000  Income Taxes Payable $25,000  Long-Term Debt $300,000 Total Liabilities $470,000 Common Stock $100,000 Retained Earnings $38,000 Total Equity $138,000 Total Liabilities and Equity $608,000 Information From Recent Budgets for the Coming Year Projected sales are $2,080,000 (13,000 units). Projected direct materials purchases are $525,000. Projected direct materials usage is $510,000. Projected direct labor expense is $420,000. Projected overhead is $390,000. Projected selling expenses are $130,000. Projected administrative expenses are $310,000. Projected cash collections are $1,805,000. Projected payments for materials (accounts payable) are $550,000. Projected payments for other operating expenses (other current liabilities) are $1,155,000. Projected depreciation expense is $60,000 and is already included in manufacturing overhead. Additional Information That Is Available The expected tax rate is 20%. The company is planning a stock issue of $50,000. Income taxes are paid 3 months after year-end. The company anticipates purchasing a new patent for $20,000 during the year. Work-in-Process Inventory is expected to decrease by $2,500. Finished Goods Inventory is expected to increase by $9,000. Due to insurance rate increases, it is expected that prepaid expenses will increase by $5,000. Investment Information A purchase of additional equipment for $80,000 is expected on January 2, 20X9. The purchase will be made using $50,000 cash and long-term debt will be increased by $30,000. Long-Term Debt Information All long-term debt will have a 9% annual rate. A payment of $50,000 including both principal and interest will be made on December 31, 20X9.   PLEASE SOLVE THE FOLLOWING: Prepare a cost of goods manufactured schedule

Principles of Cost Accounting
17th Edition
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Edward J. Vanderbeck, Maria R. Mitchell
Chapter7: The Master Budget And Flexible Budgeting
Section: Chapter Questions
Problem 4E: Prepare a cost of goods sold budget for the Crest Hills Manufacturing Co. for the year ended...
icon
Related questions
icon
Concept explainers
Question
100%

The Dawson Company has just completed a number of budgets for the coming year. The cost of goods manufactured schedule, the pro forma income statement, and the balance sheet still have to be completed.

The following information is available as 12/31/X8.

Prior Year Balance Sheet

Assets  
Cash $45,000
Accounts Receivable $55,000
Materials Inventory $40,000
Work-in-Process Inventory $30,000
Finished Goods Inventory $36,000
Prepaid Expenses $20,000
Plant and Equipment $500,000
Accumulated Depreciation ($140,000)
Other Assets $22,000
Total Assets $608,000

Liabilities and Equity

 Accounts Payable $103,000
 Other Current Liabilities $42,000
 Income Taxes Payable $25,000
 Long-Term Debt $300,000
Total Liabilities $470,000
Common Stock $100,000
Retained Earnings $38,000
Total Equity $138,000
Total Liabilities and Equity $608,000

Information From Recent Budgets for the Coming Year

  1. Projected sales are $2,080,000 (13,000 units).
  2. Projected direct materials purchases are $525,000.
  3. Projected direct materials usage is $510,000.
  4. Projected direct labor expense is $420,000.
  5. Projected overhead is $390,000.
  6. Projected selling expenses are $130,000.
  7. Projected administrative expenses are $310,000.
  8. Projected cash collections are $1,805,000.
  9. Projected payments for materials (accounts payable) are $550,000.
  10. Projected payments for other operating expenses (other current liabilities) are $1,155,000.
  11. Projected depreciation expense is $60,000 and is already included in manufacturing overhead.

Additional Information That Is Available

  1. The expected tax rate is 20%.
  2. The company is planning a stock issue of $50,000.
  3. Income taxes are paid 3 months after year-end.
  4. The company anticipates purchasing a new patent for $20,000 during the year.
  5. Work-in-Process Inventory is expected to decrease by $2,500.
  6. Finished Goods Inventory is expected to increase by $9,000.
  7. Due to insurance rate increases, it is expected that prepaid expenses will increase by $5,000.

Investment Information

  1. A purchase of additional equipment for $80,000 is expected on January 2, 20X9.
  2. The purchase will be made using $50,000 cash and long-term debt will be increased by $30,000.

Long-Term Debt Information

  1. All long-term debt will have a 9% annual rate.
  2. A payment of $50,000 including both principal and interest will be made on December 31, 20X9.

 

PLEASE SOLVE THE FOLLOWING: Prepare a cost of goods manufactured schedule

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

can you prepare a  pro forma income statement and pro forma balance sheet?

 

 

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning