Please refer to the attachment to answer this question. This… 4. Table 4 gives you the information for the last six months on the manufacturing overhead cost and machine hours. Using the high/low method of cost estimation and this information, determine the fixed and variable portions of the manufacturing overhead cost. (You will need this information to complete Table 5). Machine hours have been determined as the best cost driver for manufacturing OH. It takes one machine hour to make 200 cases of cookies. 5. Table 5 is where you will list all your production cost (DM, DL, MOH), separated into their fixed and variable components. Note this table wants variable cost per unit and annual fixed cost. 6. Cost-Volume-Profit (CVP) Relationships a. Selling Price: You sell a case of cookies for $16 b. Breakeven point: Calculate the breakeven point. Be sure to include the fixed component of mixed cost in your fixed costs and the variable component in the variable cost. Show your breakeven in Sales units and in Sales Dollars c. Profit Planning: Determine the number of units you must sell to make an annual pre-tax profit using 3 assumptions concerning your net income (profit), both in sales units and sales dollars. i. Aggressive Profit ($4,125,000) ii. Conservative Profit ($1,750,000) iii. Average Profit ($3,589,200) 7. Budgeting: a. Create a sales budget using the information for earning an average profit for the year. You will break the budget down into the four quarters for the year. (Sales tend to be consistent each quarter, you can only sale a whole unit so round-up if necessary) Use table 6 to complete the sales budget. b. Create a production budget for each quarter of the year (keep it in quarters; you do not need to break it down by month). You desire to keep 10% of next quarter’s sales in ending inventory. Sales for Qtr 1 the following year (year 2) are expected to be 160,000 cases of cookies. There is not any beginning finished goods inventory for quarter one this year. Use table 7 to complete the production budget. 8. Running quarter two — Weighted-average process costing. Table 8 presents the information for the packaging department. Complete the questions under table 8. 9. Actuals are in for quarter two. You sold 5% less units than you budgeted for (round to a whole unit), but price per unit was $16.50. a. Calculate revenue b. Compute the cost of goods sold (total and per unit) before adjusting for actual OH cost (there was not any beginning finished goods inventory for Q2) 10. Actual filling ingredients usage for quarter one was 15,925,000 grams at a price of $0.0085 per gram. Actual equivalent units of production (cases of cookies) completed through the second process (where the filling is added) was 176,000. Calculate the direct materials variances for the filling (price, usage, and total) and indicate if these variances are favorable or unfavorable. 11. Actual direct labor hours for the quarter were 62,870 at an average rate of $18.50 per hour. For actual production, you expected to use 62,756 direct labor hours. Calculate the direct labor variances (rate, efficiency and total) and indicate if these variances are favorable or unfavorable. 12. For July, you have received a special offer of 5,000 cases of cookies at a total price of $55,000. Your current capacity per month is 80,000 cases. The event organizers ordering these cookies have requested a special summer themed wrapping that will cost $1,800 for you to set-up. Should you accept or reject this offer? Why? 13. Determine over- or under-applied overhead and close to cost of goods sold. Actual OH costs are given in table 13 (look at #11 for actual DL hours used to apply OH). Determine the new cost of goods sold amount. Business Accounting Share QuestionEmailCopy link This question was created from FinalProject_Fall2021-2.doc Comments (0)
You will get a plagiarism-free paper and you can get an originality report upon request.
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more