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
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
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 |
$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 |
($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 |
$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
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
can you prepare a pro forma income statement and pro forma