I need help creating a excel spreadsheet for this problem I have trouble with excel and need help creating a a excel spreadsheet for the question in the attachment

1. The BookCases Company manufactures hand-crafted natural wood book cases. Currently the company makes only one size of book case, which is 5 feet tall and has 5 shelves. The final product consists of a routed, sanded, assembled, and stained poplar wood book case. Direct materials include poplar shelving wood and red oak plywood backing board. Other materials, such as wood screws, sand paper, stain, wood glue, and packaging, are treated as indirect materials. BookCases is preparing budgets for the fourth quarter ending December 31, 2015. For each requirement below prepare budgets by month for October, November, and December,and a total budget for the quarter. The previous year's sales (2014/15) for the corresponding period were October 2,000 book cases November 2,800 book cases December 4,000 book cases January 4,400 book cases February 3,00 book cases The company expects the above volume of book case sales to increase by 15% for the period October 2015 February 2016. The budgeted selling price for 2015 is $280.00 per book case. The company expects 40% of its sales to be cash (COD) sales. The remaining 60% of sales will be made on credit. Prepare a Sales Budget for BookCases. 1. The BookCases Company manufactures hand-crafted natural wood book cases. Currently the company makes only one size of book case, which is 5 feet tall and has 5 shelves. The final product consists of a routed, sanded, assembled, and stained poplar wood book case. Direct materials include poplar shelving wood and red oak plywood backing board. Other materials, such as wood screws, sand paper, stain, wood glue, and packaging, are treated as indirect materials. BookCases is preparing budgets for the fourth quarter ending December 31, 2015. For each requirement below prepare budgets by month for October, November, and December,and a total budget for the quarter. The previous year's sales (2014/15) for the corresponding period were October 2,000 book cases November 2,800 book cases December 4,000 book cases January 4,400 book cases February 3,00 book cases The company expects the above volume of book case sales to increase by 15% for the period October 2015 February 2016. The budgeted selling price for 2015 is $280.00 per book case. The company expects 40% of its sales to be cash (COD) sales. The remaining 60% of sales will be made on credit. Prepare a Sales Budget for BookCases