Please use three or four question from my account and do this question for me and do this for me and i would rate all of your answers.

Objectives:

1.Apply accounting manufacturing concepts to an actual product to solidify the learning process.

2.Learn how all the numbers fit together.

3.Develop decision-making analysis techniques.

Manufacturing Questions Instructions:

1. This project should stand by itself. Include the questions with your submission--not just the answers. Identify all numbers. Points will be deducted if I cannot understand what you are answering.

2. You may use Excel to complete tables and/or answer questions. Just make sure you label your work and turn the Excel file in.

3. You may discuss this project with classmates. A discussion board is available to discuss the project. Try to get help from classmates first. Your professor will only provide limited individual help, but will monitor the discussion board to make sure advice is on the right path

4. You can also print, hand write the answers, and submit a scanned copy

Your information: 1. Your company produces sandwich cookie snack packs. There are three main processes used to make the cookies. The first process preps and mixes the ingredients into the cookie and the filling. The second process shapes, forms and bakes the cookies. The third process packages the cookies. The cookies are sold in cases of 30 cookie packs (1 case is a unit) 2. Information on the direct materials is listed in table 1. Consider information the standard. Direct labor information given in Table 2. Consider this information the standard. 3. Annual overhead information is given in Table 3. Overhead is allocated based direct labor hours. Estimated annual direct labor hours are 221,800. Calculate a predetermined OH rate (round to two decimal places if needed). Use this rate when you need to apply . 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) 2 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 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 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 4% more units than you budgeted for (round to a whole unit), but price per unit was $15.75. a. b. Calculate revenue 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. Total per unit 240 grams Table 1: Direct Materials Quantity per Material unit Cookie Ingredients Filling 90 grams Packaging 1 1 box Packaging 2 30 wrappers Total cost Cost $0.0065 0.0080 0.2000 0.0250 $1.56 0.72 0.20 0.75 $3.23 Table 2: Direct Labor Job description Processor Baker Packager Hours per unit Rate 0.30 0.04 0.02 $18.00 18.00 18.00 Total cost $5.40 0.72 0.36 Total cost $6.48 Table 3: YEARLY OVERHEAD COSTS Cost description Indirect material Indirect labor Machine Maintenance Electricity Depreciation Quality testing Total Amount $14,400 72,000 19,200 6,380 21,600 54,950 $188,530 Predetermined OH rate: 4 Table 4 - Actual Overhead cost for the last six months Machine hours OH Cost Month 1 320 $16.600 Month 2 200 $14,500 Month 3 $18,460 Month 4 500 $19,900 Month 5 220 $14,860 Month 6 210 $14,680 420 *200 cases produced per machine hour Complete any calculations here: Table 5: Variable and Fixed Costs COSTS Description VARIABLE Cost per unit FIXED Cost per Year TOTAL If a cost is mixed, put the fixed amount in the fixed column and the variable amount in the variable column. CVP Calculations: 6 Table 6 - Sales Budget (Q1, Q2, Q3, Q4) Table 7 - Production Budget Qtr 1 Otr 2 Qtr 3 Otr 4 Process Costing - Packaging Department Direct materials are added 90% at the beginning of the process and the remaining 10% are added when the cookies are 80% complete with the packaging process. Direct labor and overhead are added evenly throughout the process. Table 8- Unit and cost information Physical Units Cost Direct Direct Materials Labor Transferred -in Overhead Beg WIP 12.000 (40% complete) $104,000 $10,350 $1,669.30 $78.20 $1,327,040 Transferred 160,000 In End WIP 10,000 (30% complete) Added during Qu 2: Direct Materials -- $126,450 Direct Labor - 3150 bus @ $18.50 per hour Overhead - OH is applied based on predetermined OH rate and actual DL hours 1. Determine the number of units completed during quarter 2. 2. Compute the equivalent units using the weighted average method. 8 3. Compute the cost per equivalent unit using the weighted average method 4. Compute the cost of goods transferred to finished goods inventory 5. Compute the ending balance in WIP, Packaging Table 9 - Actual Results (calculate revenue and COGS) Units sold Sales Price Revenue Units sold Cost per unit COGS Table 10 - DM Variances (filling only) Price Variance Usage Variance Total Variance Calculations: 10 Table 11 - Direct Labor Variances Rate Variance Efficiency Variance Total Variance Calculations: #12 Accept or Reject Special Order? Why? Table 13 - Actual OH cost for Quarter 2 Description Cost Indirect Materials Indirect Labor Machine Maintenance Electricity Depreciation Quality Testing $3,800 $18,000 $5,100 $2,000 $5,400 $14,820 Amount of applied OH: Amount of actual OH: Under or Over-Applied Amount: New COGS amount