Budget- Based on the inf ormation below, you are to prepare all operations budgets, financial budgets and schedules for a bicycle manufacturer Wing Bicycle Company manufactures a Sales - Their sales team has committed to the following projected monthly nd sells 2 sizes of bicycles, 21.5 inch and 22.5 inch. unit sales for the next year 21.5 Bke 22.5 Bike Jan Feb Mar Apr May unJul 368 472 1633_1616 1 443 345 322 T317 317 T3171328- 400 535 385 300 280 275 275 275 285 365 320 410 550 The selling price for the 21.5 inch bike is $455. For the 22.5 inch bike it is $490. each month is 15% of the following month's sales for the 21.5 inch bike and 12% for the 22.5 inc inventory inch bike. the 22.5 inch bike The desired ending inventory for at January 1 of the budget year is expected to be The projected sales for Jan of the year fo 55 units of the 21.5 inch bike and 38 units of the 22.5 llowing the budget are 385 of the 21.5 inch bike and 350 for taterials The total materials for the 21.5 inch bike and 22.5 inch bike are $164.45 and $186.30 respectively (eall The production department would like to have an ending raw materials inventory of 20% of the next month's of Materials in workbook for information purposes). production requirements. Desired ending production inventory for December is $15,700 for 21.5 inch bike and $15,300 for 22.5 inch bike. Beginning raw materials inventory value for Jan of the budget year are 21.5 inch bike and $18,597 for the 22.5 inch bike. $16,370 for the Direct Labor - Direct labor is 3.9 hours at $15.25 per hour for the 21.5 inch bike and 4.4 hours at $15.25 per hour for the 22.5 inch bike (Process sheet in workbook for information purposes). Manufacturing Overhead-Manufacturing overhead is based on direct labor hours at a rate of $22.25 per DLH for each of the bikes. Budgeted monthly fixed overhead is as follows: Salaries Utilities Depreciation Maintenance Insurance Property Taxes 5 5,000 2,200 7,200 2,800 2,000 1,200 Sales, General & Administrative- Sales, General and Administrative (SG&A) expenses are based on unit sales for variable expenses at $11.20 per unit. Fixed SG&A expenses are $18,000 per month Part of these SG&A expenses are non-cash and amount to $7,800 per month. Cash-Cash is expected to be collected at 55% of the prior month sales and 45% of the sales from 2 months prior Nov/Dec sales for the prior year are $422,000 and $475,000 respectively. Monthly cash disbursements for materials are 50% of current month's purchases and 50% of last month's purchases. Trade accounts payable should be based on materials purchases and the balance at Dec 31 of the year prior to the budget year is estimated to be $42,000 in the month incurred. The beginning cash balance for Jan of the budget year is Assume all other expenses are paid estimated to be $ 39,979. The company has estimated balance sheet amounts as of $1,280,000 for Property, Plant & Equipment, $2,125,000 for Common Stock and Ret Jan 1 of $225,000 for Land, ained Earnings of $510,915