Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started