Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please pleeease help me. I have been struggling for 3 days to find the answer. Combined cash budget January February March Quarter Cash balance, beginning

Please pleeease help me. I have been struggling for 3 days to find the answer.

Combined cash budget

January February March Quarter

Cash balance, beginning

Add cash collections

Total cash available

Less cash payments:

Direct material purchases

Conversion costs

Operating expenses

Equipment purchases

Tax payment

Total disbursements

Ending cash balance before financing

Financing:

Borrowings

Repayments

Interest payments

Total financing

Cash balance, ending

Budgeted Manufacturing per unit:

Direct materials cost per unit

Conversion costs per unit

Fixed manufacturing overhead per unit

Budgeted cost of manufacturing each unit

Units to produce

Budgeted Income statement

Sales

Cost of goods sold

Gross profit

Operating expenses

Depreciation expense

Operating income

Less interest expense

Less provision for income taxes

Net Income

I NEED ANSWER FOR Budgeted Manufacturing Cost per Unit account and Budgeted Income statement and balance sheet. Please show calculations if possible. Thank you Current assets as of December 31 (prior year):

Cash $4,650.00, Accounts receivable, net $57,600.00, Inventory $15,600.00; Property, plant, and equipment, net $121,500.00; Accounts payable $42,800.00; Capital stock $124,500.00; Retained earnings $22,800.00

A: Actual Sales in December were$72,000. Selling price per unit projected to remain stable at $12 per unit throughout the budget period. Sales for the first five months of the upcoming year are budgeted to be as follow: January $ 104,400 , February $ 108,000 , March $ 112,800 , April $ 109,200, May $ 105,600

B: Sales are 20% cash and 80% credit. All credit sales are collected in the months following the sale.

C: the company has a policy that states that each months ending inventory of finished goods should be 10% of the following month's sales (in units)

D: Of each month's direct material purchases, 20% are paid for in the month of purchase, while the remainder is paid for in the month following purchase. 3kg of direct material is needed at $2.00 per kg. Ending inventory of direct materials should be 30% of next month's production needs

E; Monthly manufacturing conversion costs Factory rent $ 4,500.00, Other fixed manufacturing expenses $ 2,800.00, Variable manufacturing overhead ($1.10 per unit) $ 1.10, No depreciation is included in these figures. All expenses are paid in the month in which they are incurred

F: Computer equipment for administrative offices will be purchased in the upcoming quarter incurred, In January, Osborne Manufacturing will purchase January purchase - equipment for $6000 (cash). February cash expenditure will $ 12,800.00, March cash expenditure $15,600.00

g: Operating expenses are budgeted to be $1.30 per unit sold $ 1.30 , Plus fixed operating expenses of 1800 per month $ 1,800.00. All operating expenses are paid in the month in which they are incurred.

H: Depreciation on the building and equipment for the general administrative offices is budgeted to $4600 for the entire quarter, which includes depreciation on new acquisitions. Depreciation on the building and equipment budget $4,600.00

I: The Company has a policy that the ending cash balance in each month must be at least $4200, The Company has a line of credit with a local bank. It can borrow increments of $1000 at the beginning of each month up to a total outstanding loan balance of $130,000. The interest rate on these loans is 2% per month simple interest. The company pays down on the line of credit balance if it has excess funds at the end of the quarter. The company also pays the accumulated interest at the end of the quarter on the funds borrowed during the J: The company's income tax is projected to be 30% of operating income less interest expense. The company pays $10800 cash at the end of February in estimated taxes

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting An Integrated Approach

Authors: Michael Gibbins

6th Edition

0176407251, 978-0176407254

More Books

Students also viewed these Accounting questions

Question

=+What are the actions in this decision process?

Answered: 1 week ago

Question

4 What are the main practices associated with SHRM?

Answered: 1 week ago