please complete table

Master Budget Project Husker Corporation is a manufacturing company that produces ene pesduct. The Corperation is working on their 1 e quarter budget and newds your help. The master budget will be bases on the following infecmation: a. Unit sales for the upcoming year are projected an foliows: Jan. 250, Fub, 300. March 200, Aprit 350 and May 275. b. The selling pries is $30 per unit. c. Husker Corporation's desired ending inveritory for finished goods is 20% of next monthis sales. d. Fach finished 900d takes 1/2 heur of direct labor and 3 units of direct muterialu. Employees are paid $9.50 per hour, and one unit of drect materats costs 12.58 . e. At the end of each meeth, Musker Corp. plans to have 30s dof the direct materlais needed for the next monthis preductign units. f. Fined overtuad totals 542,000 for the entire year, of this tocal, 512,000 represents depreclation. All other fixed expenses are paid for in cash in the moneh incured. The fixed overhead rate per wnit is 54.50 ,unit (note this is based on estimates for the entire year). 9. Variable overthead is bodgeted at 2 per unit predaced. Al variable overhead expenses are paid for in the month incuered. h. Ficed selling and administrative expenses total s2,400 per year, including 1600 depreclatign per year- 1. Variable selling and administrative eippenses are budgetest at 11.50 per unit told. Al seiting and adminstrative expenses are paid for in the month incurred. 1. All males are credit cales. Beaker Corp. collecti 65% of all sales within the month of the sale and the ether asth is collected in the following month. There are no bad debts. Accosnts receivable at year end fotaled 52,262.50. k. Hunker Corp, burs direct makerals on accecent. Half of the purchases are paid for in the month of acquisition, and the remairing haif are paid for in the folloming menth. Accesents payable at the end of last vear totaled 51.000.00. 1. In March, 52,000 of equipment will be purchased with cash. m. The beginning cash balance at the beginning of the budgeted year is 512,000