Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I NEED ANSWER FORCombined Cash Budget Combined Cash Budget account and Budgeted Manufacturing Cost per Unit account and Budgeted income statement and balance sheet. Please

I NEED ANSWER FORCombined Cash Budget Combined Cash Budget account and 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 incurredF:Computer equipment for administrative offices will be purchased in the upcoming quarter. In January, Osborne Manufacturing will purchaseJanuary purchase - equipment for $6000 (cash). February cash expenditure will$12,800.00, March cash expenditure$ 15,600.00g: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 incurredH: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.00I: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 intersest. 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 quarterJ: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

Accounting Information Systems

Authors: James Hall

9th Edition

1305465113, 9781305465114

More Books

Students also viewed these Accounting questions

Question

=+3. How does accolade courage affect others?

Answered: 1 week ago

Question

1. What does this mean for me?

Answered: 1 week ago