Master budgets using excel to prepare an operating budget (manufacturing company) thunder creek company is preparing budgets for the first quarter of 2018. all relevant information is presented on the excel template. use the blue shaded areas on the enter-answers tab for inputs. always use cell references and formulas where appropriate to receive full credit. enter all amounts as positive values. do not use a minus sign or parentheses for any values. requirements possible points 1. prepare a sales budget. 18 2. prepare a production budget. 26 3. prepare a direct materials budget. 39 4. prepare a direct labor budget. 20 5. prepare a manufacturing overhead budget. 33 6. prepare a cost of goods sold budget. 20 7. prepare a selling and administrative expense budget. 20 excel skills             1. create formulas with cell references.             2. use the round function.