Prepare a Master Budget and Supporting Schedules Dimash Inc. is a recreational outfitter that provides quality products based around fun and water. The Company is now considering expanding its offerings to include specialty touring kayaks. Kayak By Design concept grew out of inspiration and experience of its resident sportsman and craftsman, Dimash Kudaibergen. Long before the paddle enters the water, each Kayak design begins with a pen stroke. With prototype in hand, the goal now is to open a Kayak Design and Sales Center on January 1, 2022. To make the decision, Dimash planning group requires a master budget for the center's first quarter of operation (i.e., January, February, March of 2022). Requirements: Based on the following estimates, you are asked to construct a three-month master budget for the months January, February and March. a. The Company owners will contribute $30,000 cash to get this center started. b. Its capital expenditures projection require that the Company purchase $208,000 of equipment on January 2 for the new center. The equipment supplier allows a thirty-day trial period. The company expects pay for the equipment on or before January 31, 2022. The equipment is expected to have a 10- year useful life and a $18,000 salvage value. c. Market research and various meetings with sales staff has produced the following sales projections: January 400 kayaks February 450 kayaks March 500 kayaks April 600 kayak Each Kayak is priced to sell at $750.50% of the sales will be cash and 50% will be credit. Prepare a sales budget. d. The company expects to collect 30% of accounts receivable in the month of sale and 70% of accounts receivable in the month following the sale. Prepare a schedule of expected cash receipts. c. The company policy is to have finished goods ending inventory of Kayaks in a month equal to 20% of the next month's anticipated sales. Prepare a production budget f. Production of each kayak requires 54 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). The company policy is that the ending inventory of polyethylene powder should be 25% of the amount needed for production in the next month. The finishing kits can be assembled as they are needed. The company maintains a smaller inventory of the finishing kits, only 10% of the number needed for production in the next month. The polyethylene powder used in these kayaks costs $1.75 per pound, and the finishing kits cost $140 each. Prepare a direct materials budget. g. Materials inventory purchases will all be on account. The company would pay 80% of accounts payable in the month of purchase. It will pay the remaining 20% in the following month. Prepare a schedule of expected cash payments for inventory purchases. h. Production of a single kayak requires 2 hours of time by more skilled type I employee and 3 hours of finishing time by less skilled type II employees. Type I employees are paid $18 per hour, and type II employees are paid $14 per hour. Prepare a labor budget. 100% of direct labor is paid in the month incurred. i. Manufacturing overhead is assigned at 150% of labor costs. Depreciation on equipment is included in the assigned overhead (i.e., covered by the 150% rate). Prepare a manufacturing overhead budget. Manufacturing overhead, except depreciation, is paid in the month incurred. j. Use the information developed in requirements above to determine Cost per Kayak. k. Prepare a selling and administrative expense budget. Budgeted monthly selling and administrative expenses are: $ 30 Variable Cost per unit sold* Fixed Cost Salary Expense Rent Utilities Miscellaneous Insurance 20,000 4,500 1,400 1,350 500 * Variable cost of $30 includes sales commission of $20 per unit sold. Variable cost of $30 includes sales commission of $20 per unit sold. 1. Sales commission and utilities are paid in the month after the month in which they are incurred. All other expenses are paid in the month in which they are incurred. Prepare a schedule of cash payments for selling and administrative expenses. m. The company is subject to 20% income tax. n. Using a line of credit, the company borrows and repays principal in increments of $1,000 on the last day of the month as needed. It pays interest of 0.5 percent (i.e. half of 1%)) per month in cash on the last day of the month. Company policy is to maintain an ending cash balance of at least $20,000. Use this and other information developed in requirements above to prepare a cash budget