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.

Jurvin enterprises is a manufacturing company that had no beginning inventories. a subset of the transactions that it recorded during a recent month is shown below. $76,700 in raw materials were purchased for cash. $71,400 in raw materials were used in production. of this amount, $66,300 was for direct materials and the remainder was for indirect materials. total labor wages of $151,700 were incurred and paid. of this amount, $134,300 was for direct labor and the remainder was for indirect labor. additional manufacturing overhead costs of $126,300 were incurred and paid. manufacturing overhead of $126,800 was applied to production using the company's predetermined overhead rate. all of the jobs in process at the end of the month were completed. all of the completed jobs were shipped to customers. any underapplied or overapplied overhead for the period was closed to cost of goods sold.required: 1. post the above transactions to t-accounts.2. determine the cost of goods sold for the period.

"in my opinion, we ought to stop making our own drums and accept that outside supplier's offer," said wim niewindt, managing director of antilles refining, n.v., of aruba. "at a price of $21 per drum, we would be paying $4.70 less than it costs us to manufacture the drums in our own plant. since we use 70,000 drums a year, that would be an annual cost savings of $329,000." antilles refining's current cost to manufacture one drum is given below (based on 70,000 drums per year):

Anew firm is developing its business plan. it will require $615,000 of assets, and it projects $450,000 of sales and $355,000 of operating costs for the first year. management is reasonably sure of these numbers because of contracts with its customers and suppliers. it can borrow at a rate of 7.5%, but the bank requires it to have a tie of at least 4.0, and if the tie falls below this level the bank will call in the loan and the firm will go bankrupt. what is the maximum debt ratio the firm can use? (hint: find the maximum dollars of interest, then the debt that produces that interest, and then the related debt ratio.)a. 41.94%b. 44.15%c. 46.47%d. 48.92%e. 51.49%