Instructions: Use the Balance Sheet below for Creasy, Inc plus the additional information provided on the next tab to create the operating budget, cash budget, budgeted income statement, and budgeted balance sheet for Creasy Inc. Creasy Inc. June 30, 2021 Assets Cash Accounts Receivable Raw materials Inventory Finished goods inventory 100,000 720,000 185,220 431,250 Total current Assets 1,436,470 Equipment Net 600,000 Less: Accumulated Depreciation (42,000) Equipment Net 558,000 Total Assets 1,994,470 Llabilities and Equity Accounts Payable 308,700 Short-term notes payable 25,000 Total current liabilities 333,700 Long-term note payables 500,000 Total Liabilities 833,700 Common stock 1,000,000 Retained earnings 160,770 Total stockholders' equity 1,160,770 Total liabilities + equity 1,994,470 Additional Information a) Sales for June totalled 20,000 units. Expected sales (in units) are: 23,000 (July); 25,000 (August); 27,000 (September); 23,000 (October) The product's selling price is $40/unit b) Company policy calls for the given month's ending findished goods inventory to equal 75% of the next month's expected unit sales. The June 30 finished goods inventory is 17,250 units, which complies with the policy. The products' manufacturing cost if $25 per unit, inlcluding per unit costs of $12.60 for materials (3 lbs. at $4,20 per lb.) $10 for direct labor (0.5 hours x $20 direct labor rate per hour) $1.80 for variable overhead, and $0.60 for fixed overhead Fixed overhead consists of $7,000/month for depreciation and $8,000/month for rent. Company policy also calls for a given month's ending raw materials inventory to equal 60% of next month's expected materials needed for production. The June 30 inventory is 44,1000 pounds units of materials, which complies with the policy. The company expects to have 46,350 pounds of materials inventory on September 30. c) Sales representatives' commissions are 9% of slaes and are paid in the month of the sales. The sales manager's monthly salary will be $5,000 in July and August and will increase by 5% in September d) Monthly general and administrative expenses include $10,000 administrative salaries and 0.3% monthly interest on the long term note payable. e) The company expects 10% of sales to be for cash and the remaining 90% on credit. Receivables are collected in full in the month following the sale (none is collected in the month of the sale). f) All direct materials purchases are on credit, and no payables arise from any other transactions. One month's purchases are fully paid in the next month. Materials cost $4.20 per pound. g) The minimum ending cash balance for all months is $100,000 If necessary, the company borrows enough cash using a short-term note to reach the minimum. Short-term notes require an interest payament of 0.5% at each month-end (before any repayment). If the ending cash balance exceeds the minimum, the excess will be applied to repaying the short-term notes payable balance. h) Dividends of $80,000 are to be declared and paid in July. i) No cash payments for income taxes are to be made during the third calendar quarter. Income taxes will be assessed at 22% in the quarter. j) Equipment purchaes of $25,000 are scheduled September. Sales Budget July August September October Budgeted sales in units Price/unit Budget sales in $ Production Budget July August September Budgeted Ending Inventory Budgeted Sales units Less Beginning Inventory Total units to be produced in the period Direct Materials Budget Budgeted production units x materials required for each unit (in pounds) Total budgeted material required +Budgeted ending materials inventory -Beginning material inventory Total materials to be purchased in pounds Price per pound Total budgeted materials to be purchased in dollars Direct Labor budget Budgeted production units x direct labor required for each unit Budgeted Direct labor hours x direct labor cost per hour Budgeted direct labor dollars Factory Overhead Budget 0 July August September July August September July August September Budgeted production units x variable factory overhead rate Budgeted variable overhead Budgeted fixed overhead Budgeted total Overhead