Need accounting help to modify an accounting assignment answer.

User Generated

fjrrgsnasna5

Business Finance

Description

I already have the answers from my classmates, but anyway I need to change the work or 'speaking style' to make it looks like different with my classmate, to make sure it won't hurt anyone in our class because if 'cheating stuff'. It need to be done before tomorrow 1:00pm. 

The question and answers are attached. Have three sample of the answers. the first one which is 'formal answer online' and 'ACTi-6691 right answer' are prefer.  Thanks

2014 MBAi Case.docx formal answer online (prefer).docx ACTi-6691 right answer.docx MBAi-6691-Case- something wrong.docx 

Unformatted Attachment Preview

ACTi 6691 Financial/Managerial Accounting for International Executive Case In this case a full set of budgets will be prepared and presented in appropriate format. Reports will be prepared to explain how budget numbers were determined. The following are general requirements for this budget case. Specific requirements are listed after the relevant case data. • • • • • Read the case and analyze the information. Prepare an operating budget in standard “income statement” format. Prepare a narrative report (or notes to the income statement) addressing why/how quantitative items were selected. The following items must be explained: 1. Sales Forecast 2. Purchases budget (raw materials, labor, all resources) 3. Operating Expenses Prepare a cash budget using any acceptable format. The following items must be explained or shown on the budget: 1. The process by which cash inflows were projected. 2. The process by which cash outflows were projected. 3. The process by which financing, if applicable, was determined. 4. How interest and other financing charges were calculated. Prepare a capital budget using any acceptable format. You will be graded on your understanding of the underlying concepts related to determining budget amounts (for example, how purchases are determined) as well as your ability to prepare and explain standard business reports. The rubric attached as the last page of this document will be used to grade the case. Harvey’s Budget1 Harvey Manufacturing manufactures and sells two industrial products: a self-balancing screw driver and a self-balancing saw. Both products are manufactured in a single plant. Harvey’s general manager, Mr. Lipscomb, and president, Mr. Owens, want a budget prepared for the fiscal year 2013. They have asked various employees to gather information that they believe will be necessary for preparation of a budget. The information is presented below. Neither Mr. Lipscomb nor Mr. Owens is skilled in budget preparation. Both executives have used budgets and have participated to some degree in budget preparation in prior years, but neither has prepared a full budget. Sales and selling price per unit Historical sales for 2012 the two products are shown below. Product Sales for 2012 Screwdriver Saws Units SP Units January 52,000 98 42,000 February 53,000 98 42,000 March 55,000 98 40,000 April 60,000 100 40,000 May 64,000 100 41,000 June 64,000 102 42,000 July 64,000 102 40,000 August 63,000 102 39,000 September 61,000 100 40,000 October 60,000 100 37,000 November 65,000 100 38,000 December 59,000 100 39,000 SP 118 120 122 125 125 130 130 130 125 125 125 125 Harvey’s sales typically peak in the summer months, beginning with May. Harvey’s general manager, Mr. Lipscomb, recommends that the budget be prepared with the units sold in the high sales months of May, June, and July be used as the bases for determining the annual forecast. Mr. Lipscomb’s recommendation is that annual sales be budgeted at 64,000 per month for screwdrivers and 42,000 per month for saws. Mr. Lipscomb also believes that the budgeted selling price per unit should be equal to the highest selling price that could be achieved in 2012. He would like to budget 102 per unit for screwdrivers and 130 per unit for saws. Mr. Lipscomb states that his management team experimented with pricing in the prior year, beginning with the first month of the year. You review the unit sales and unit selling price information for 2012 and recommend a budget based on 60,000 units of screwdrivers at 100 each and 40,000 units of saws at 125 each. Mr. Lipscomb challenges your conclusion. Likewise Mr. Owens, the company president, would like to hear an explanation of the budget numbers and how or why you calculated those numbers. Production Requirements Each unit produced requires the following materials, labor, and overhead, all of which is variable. Standard costs per unit Screwdrivers Units Unit cost 5 lbs 8.00 3 lbs 5.00 1 unit 3.00 Direct materials Metal Plastic Handles Direct labor Variable manufacturing OH Total 2 2 hrs hrs 12.00 1.50 Cost 40.00 15.00 3.00 58.00 Units 4 3 24.00 3.00 85.00 3 3 lbs lbs Saws Unit cost 8.00 5.00 Cost 32.00 15.00 47.00 hrs hrs 16.00 1.50 48.00 4.50 99.50 Inventories Inventories are listed below. The beginning inventories are the actual amounts on hand at the beginning of the year. The ending inventories shown are the amounts that the operations manager has determined to be necessary to ensure smooth production processes. Inventories Screwdrivers, finished Saws, finished Metal Plastic Handles Beginning 20,000 8,000 320,000 29,000 6,000 Ending 25,000 10,000 36,000 32,000 7,000 Other information Fixed manufacturing overhead Fixed manufacturing overhead is 214,000, including 156,000 of non-cash expenditures. Fixed manufacturing overhead is allocated on total units produced. Beginning cash is 1,800,000. Sales are on credit. Sales are collected 50 percent in the current period and the remainder in the next period. There are no bad debts. Sales for the last quarter were 8,400,000. Purchases for direct materials and labor costs are paid for in the quarter acquired. Manufacturing overhead expenses are paid in the quarter incurred. Selling and administrative expenses are all fixed and are paid in the quarter incurred. Estimated selling and administrative expenses for the next period are 340,000 per quarter, including 90,000 of depreciation. REQUIREMENTS: 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. Prepare a sales budget in good form. Prepare a narrative report explaining how your sales budget was determined. Use the table above in your analysis. (Hint: Many companies would develop their budgets using average sales and average unit costs.) Whatever budget determination method you use should be explained. In your explanation, you should include a discussion of why you believe sales and selling prices fluctuated last year. Prepare a production budget in units. Prepare a purchases budget. Remember that you will need to purchase enough materials to have the required ending inventories shown. You will also need to purchase enough to manufacture and sell the products on your sales forecast. Do not forget that you have beginning inventories. Prepare a narrative report explaining how you prepared the purchases budget. Be as detailed as necessary to be sure that the president and general manager will understand the calculations and costs. Prepare a budgeted income statement. Prepare a contribution margin income statement. Prepare a narrative report explaining how the expenses on the income statement were determined. Prepare a cash budget. Be sure that you show all cash inflows and outflows. Prepare a narrative report explaining your cash budget process. If necessary, prepare a capital expenditure budget. Explain your entries. Use only the facts in this case to prepare the budget. Summary: Your finished case will consist of six or seven budgets (a sales budget, a production budget in units, a purchases budget, a budgeted income statement, a contribution margin income statement, a cash budget, and, if necessary, a capital expenditure budget.) You will also have four or five narrative reports (a sales budget report, a purchases budget report, an income statement report, a cash budget report, and an explanation of your capital budget, if necessary). Narrative reports are reports that are in the form or a white paper that clearly explains the numeric entries on your budgets. The length of the narrative reports will depend on the particular report. In general, you should be able to prepare the sales budget report on one or two pages, the purchases budget report on one or two pages, the income statement report on one page, and the cash budget report on one page. In this case, the capital budget report would be less than one page. You should not worry if one of your reports is more or less than the recommendation given here—just be sure you cover all of the important points and satisfactorily explain the numeric entries in your budget. Also, be sure you explain the process of “how” your numbers were determined. In this regard, it is not necessary or desirable to explain the exact calculations. Consider your audience and prepare a report that would be suitable for executives making plans and decisions for the upcoming year. 1 Harvey’s budget is adapted from a published case. (Source and citation are available upon request to faculty only). MBAi 6691 Student: Date Scored Case Grading Rubric Criteria for Case Meets Expectations Analysis addresses all aspects of case in sufficient depth. Partially Meets Expectations Analysis addresses most aspects of case in sufficient depth. Fails to Meet Comments/Score Expectations Analysis does not address most aspects of case and/or fails to do so in sufficient depth. Content Solution (worth 40% of the case grade) Described solution demonstrates an understanding and correct use of problem solving skills Described solution demonstrates a sufficient level of problem solving abilities but fails to address correctly as aspects of the case. Described solution does not demonstrate an acceptable level of problem solving abilities and the ability to use case information correctly. Presentation Style (worth 20% of the case grade) No significant Errors in The presentation errors in presentation was limited, presentation style, compliance demonstrated a style, with case minimal effort to consistent requirements, meet case with case and normal requirements requirements business and present your and consistent standards solution in an with business acceptable standards business style. Content Analysis (worth 40% of the case grade) Late Submission 10% per day regardless of the reason for the late submission. Total Points Harvey’s Budget Case Financial/Managerial Accounting for International Executive Case 1. Sales Budget Sales Budget for The Year Ending December 31,2013 Units Selling price Revenues per Month Total Revenues Screwdriver 60,000 $100 $6,000,000 $72,000,000 Saws 40,000 $125 $5,000,000 $60,000,000 Total $132,000,000 A sales budget is the usual starting point for the operating budget, because the sales budget helps businesses predict the amount they will earn when they sell their products and services. Mr. Lipscomb believes the annual sales should be budgeted at 64,000 per month for screwdrivers and 42,000 per month for saws, and the budgeted selling price per unit should be equal to the highest selling price (102 per unit for screwdrivers and 130 per unit for saws) that could be achieved in 2012. I do not agree with this budget recommendation. I use the average sales and average unit price for determining the future operations, for the company did not have the enough confident and information for predicting the accurate growth rate of sales for the next year. Besides, the sales units and sales price for both Screwdriver and Saws are vary each month. The reason for the Sales and selling prices fluctuating is the market demand is different for each month. There are more construction works or tools needed for summer than the demand in winter. If the sales budget be prepared with the units sold in the high sales months of May, June, and July be used as the bases for determining the 1 Harvey’s Budget Case annual forecast, the budget will overestimate the amount and related price. The sales budget cannot describe the future amount the company will earn accurately. Therefore, using the average units of sales (60,000 units of screwdrivers and 40,000 units of saws) and unit price (100 per unit for screwdrivers and 125 per unit for saws) for every month is the best estimation for the sales budget. 2. Production Budget Production Budget(in Units) for the Year Ending December 31,2013 Product Screwdrivers Saws Budgeted Unit Sales 720,000 480,000 Target Ending Finished Goods Inventory 25,000 10,000 Total Required Units 745,000 490,000 Beginning Finished Goods Inventory 20,000 8,000 Units of Finished Goods to be Produced 725,000 410,000 3. Purchases Budget Schedule A:Direct Material Usage Budget in Quantity and Dollars for the Year Ending December 31,2013 Material Metal Plastic Handles Physical units Budget Direct Materials required for Screwdrivers(725,000 units) 3,625,000 lbs 2,175,000 lbs Direct materials required for Saws(410,000 units) 1,640,000 lbs 1,230,000 lbs Total quantity of direct materials to be used 5,265,000 lbs 3,405,000 lbs 725,000 lbs 725,000 lbs Cost Budget Available from beginning direct material inventory Metal: 320,000 lbs $2,560,000 Plastic: 29,000 lbs $145,000 Handles: 6,000 lbs $18,000 To be Purchased this period Metal: (5,265,000-320,000) lbs $39,560,000 2 Total Harvey’s Budget Case Plastic: (3,405,000-29,000) lbs $16,880,000 Handles: (725,000-6,000) lbs $2,157,000 Direct Materials to be used this period $42,120,000 $17,025,000 $2,175,000 $61,320,000 The number of units to be produced is the key to computing the usage of direct materials in quantities and in dollars. Because the Purchases of Direct materials equals to direct materials used in production plus Target ending inventory of direct materials minus beginning inventory of direct materials, we need to figure out the Direct Materials to be used this period. According to the sales budget we made before, we know there are 725,000 units of Screwdrivers and 410,000 units of Saws to be produced in 2013. For the production of each unit, the company needs the direct materials as below: Then we can calculate the quantity of each type of direct materials to be used. For the production of 2013, the company needs 5,265,000 lbs of metals, 3,405,000 lbs of plastic and 725,000 lbs of handles. Because there are beginning direct materials inventory exist, subtract the inventory from the total quantity of direct materials to be used to get the amount of materials to be used during 2013. Of course, we also can calculate the dollar values of these materials for a later use. Schedule B: Direct Material Purchases Budget for the Year Ending December 31,2013 Material Metal Plastic Handles Physical Units Budget To be used in production Target ending inventory 5,265,000 lbs 3,405,000 lbs 725,000 lbs 36,000 lbs 32,000 lbs 7,000 lbs 3 Total Harvey’s Budget Case Total requirements Beginning inventory Purchases to be made 5,301,000 lbs 3,437,000 lbs 732,000 lbs 320,000 lbs 29,000 lbs 6,000 lbs 4,981,000 lbs 3,408,000 lbs 726,000 lbs Cost Budget Metal: 4,981,000 lbs $39,848,000 Plastic: 3,408,000 lbs $17,040,000 Handles: 726,000 lbs Purchases $2,178,000 $39,848,000 $17,040,000 $2,178,000 $59,066,000 After we get the budget for how many materials will be used in production, we know there are 5,265,000 lbs of metal, 3,405,000 lbs of plastic and 725,000 lbs of handles to be used. Add the target ending inventory to find out the total requirement for direct materials. The total materials requirements for metal are 5,301,000 lbs, for plastic are 3,437,000 lbs and for handles are 732,000 lbs. At last, deduct the beginning materials inventory to get how many direct materials the company need purchase. The company needs purchase 4,981,000 lbs of metal, 3,408,000 lbs of plastic and 726,000 lbs of handles to meet the production need for 2013. We already know each unit of metal, plastic and handle costs $8, $5 and $3.According to this budget, we can figure out how much many the company need to pay for purchasing these direct materials. The total budget for direct materials purchasing is $59,066,000. 4. Budgeted Income Statement. Harvey Manufacturing Budgeted Income Statement For the Year Ending December 31,2013 Revenues $132,000,000 Cost of goods sold $102,010,000 Gross margin $29,990,000 Operating Cost Selling and administrative $1,360,000 Net Income $1,360,000 $28,630,000 4 Harvey’s Budget Case For the budgeted income statement, we already know the budgeted revenue is $132,000,000, and the $1,360,000 of Selling and administrative expenses is given, what we need to figure out is the Cost of Goods Sold. So I prepared the Cost of Goods Sold Budget for 2013 as below: Cost of Goods Sold Budget for the Year Ending December 31,2013 Schedule Beginning Finished goods inventory, January 1,2013 Direct materials used Direct manufacturing labor Total Given $2,496,000 A $61,320,000 Given $37,080,000 Manufacturing overhead Variable Given $4,020,000 Fixed Given $214,000 $4,234,000 Cost of goods manufactured $102,634,000 Cost of goods available for sale $105,130,000 Deduct Ending Finished Goods Inventory, December 31,2013 Given Cost of Goods Sold $3,120,000 $102,010,000 The Cost of Goods Sold equals to the Beginning Finished goods inventory plus direct materials used and direct manufacturing labor and manufacturing overhead, then deduct the Ending Finished Goods Inventory. The $2,496,000 of Beginning Finished goods inventory, $37,080,000 of direct manufacturing labor, $4,234,000 of manufacturing overhead, and $3,120,000 of Ending Finished Goods Inventory are already given. Besides; we can get that $61,320,000 of direct materials will be used during production from the Budget Schedule A. Use the formula I mentioned; we can calculate the amount of Cost of Goods Sold is $102,010,000. Subtract the cost of goods sold and operation cost, we can get $28,630,000 of budgeted net income. 5. Contribution Margin Income Statement 5 Harvey’s Budget Case Harvey Manufacturing Budgeted Contribution Margin Income Statement For the Year Ending December 31,2013 Revenues $132,000,000 Variable production Expenses Direct materials $61,320,000 Direct labors $37,080,000 Variable manufacturing overhead $4,020,000 $102,420,000 Variable Selling and Administrative Expenses $0 Contribution Margin $29,580,000 Fixed Expenses $950,000 Net Income $28,630,000 6. Cash Budget Harvey Manufacturing Cash Budget For the Year Ending December 31,2013 Quarters 1 Cash balance, Beginning 2 3 4 Year as a Whole $1,800,000 $(2,688,750) $5,122,500 $12,933,750 $1,800,000 $4,200,000 $16,500,000 $16,500,000 $16,500,000 From current period $16,500,000 $16,500,000 $16,500,000 $16,500,000 $119700000 Total Cash available for needs $22,500,000 $30,311,250 $38,122,500 $45,933,750 $121500000 $14,649,250 $14,649,250 $14,649,250 $14,649,250 $58,597,000 Payroll $9,270,000 $9,270,000 $9,270,000 $9,270,000 $37,080,000 Manufacturing overhead $1,019,500 $1,019,500 $1,019,500 $1,019,500 $4,078,000 Nonmanufacturing Cost $250,000 $250,000 $250,000 $250,000 $1,000,000 Cash excess(deficiency) $(2,688,750) $5,122,500 $12,933,750 $20,745,000 $20,745,000 Cash balance End $(2,688,750) $5,122,500 $12,933,750 $20,745,000 $20,745,000 Collections From Customers From last period Deduct Disbursement Direct materials The cash budget is the schedule of expected cash receipts and disbursements. It 6 Harvey’s Budget Case predicts the effects on the cash position at the given level of operations. I prepared the cash budget by quarters to show the impact of cash flow. First we need to know how much money the company will get each quarter. According to the Sales budget and the information that sales are collected 50 percent in the current period and the remainder in the next period and there are no bad debts, we calculate out the cash inflow for each quarter. The amount of first quarter is a little bit different, because the sales for last quarter were $8,400,000. We only can collect $4,200,000 from last year during the first quarter. According to the Purchases Budget, the company need spend $39,560,000 to purchase metals, $16,880,000 to buy plastic and $2,157,000 to get handles. Therefor we can conclude that the company needs $14,649,250 for purchasing materials. Through viewing the production Budget, we can get there are 725,000 units of Screwdrivers and 410,000 units of Saws will be produced. The average labor cost is $24 for Screwdriver and $48 for Saw. The each unit cost of manufacturing OH is $3 for Screwdriver and $4.5 for Saw. The total fixed manufacturing overhead is $214,000, including $156,000 of non-cash expenditures. So we exclude this non-cash expenditure from the cash budget. Then we can get that company need pay salary for the labor $9,270,000 each quarter and pay $1,019,500 for the manufacturing overhead expenditure. The Selling and administrative expenses are all fixed and are paid in the quarter incurred. Estimated selling and administrative expenses for the next period are 7 Harvey’s Budget Case $340,000 per quarter, including $90,000 of depreciation. Just deduct the depreciation expense from nonmanufacturing cost, we can calculate out the company need pay $250,000 each quarter for nonmanufacturing cost. At last, subtract all of the cash disbursements from the cash available to get the cash balance for each quarter. 7. Capital Expenditure Budget Harvey Manufacturing Capital Expenditure Budget Quarter 1 Total Financing Borrowing(at beginning) $2,688,750 $2,688,750 Budgeting for capital expenditures involves setting aside or saving money for a purchase or electing to add debt to your balance sheet for the purchase of the capital asset. According to the cash budget, the company does not have enough cash for supporting its first quarter operations. So the company need borrow the money to prepare for its deficit. During the first quarter, there will be $2,688,750 of cash deficiency. The company need budget to borrow $2,688,750 at the beginning of the 2013 to mitigate this cash shortage. Of course, this will increases the debt and cause a problem for future borrowing ability. 8 Mathieu Salmon ACTi 6691 Financial/Managerial Accounting for International Executive Case 1) Prepare a sales budget in good form. Screw Driver Saws Units 60000 40000 Selling price per unit $ 100 $ 125 $ 6,000,000 $ 5,000,000 Total sales Total sales ( SD+ Saws) $ 11,000,000 2) Prepare a narrative report explaining how your sales budget was determined. The sales budget was prepared based on the unit sales and unit selling price information for 2012 at Harvey’s. 60,000 units of screwdrivers at 100 each and 40,000 units of saws at 125 each seemed to be the most appropriate numbers to choose depending on the previous historical sales for 2012 at Harvey’s. The company is selling two industrial products: a self-balancing screw driver and a self-balancing saw. The budget recommended here is to sell 60000 screw drivers per month in 2013 at the unit selling price of $100 and 40000 saws per month at a unit selling price of $125. The total sales for each product are shown as well as the final budgeted total sales. The basis of the previous periods (2012) gives the best estimate for forecasting the future data necessary for the sales budget. 3) Prepare a production budget in units. Screw Driver Saws Sales (units) 60000 40000 Add: Ending inventory 25000 10000 Less: Beginning inv 20000 8000 Production 65000 42000 Mathieu Salmon The production budget was prepared based upon the sales (budgeted), the beginning and the ending inventory (data given). Explanation: Sales (budgeted) + Ending Inventory – Beginning Inventory = Production (budgeted) 4) Prepare a purchases budget. Metal Plastic Handles Screw drivers Production (in units) 65000 65000 65000 5 3 1 325000 195000 65000 42000 42000 None 4 3 None Material required (units Z) 168000 126000 None Total material required (Y + Z) 493000 321000 65000 36000 32000 7000 Less: Beginning inventory 320000 29000 6000 Purchases (in units) 209000 324000 66000 $8 $5 $3 $ 1,672,000 $ 1,620,000 $ 198,000 Material required (per unit) Material required (units Y) Saws Production (in units) Material required (per unit) Add: Ending inventory Unit cost Purchases Total purchases $ 3,490,000 5) Prepare a narrative report explaining how you prepared the purchases budget. The production budget helped in the preparation of the purchases budget for the screw drivers and the saws. Metal, plastic, and handles are the materials that have to be purchased in order to produce. 325000 units of metal (65000*5), 195000 units of plastic and 65000 units of handles are required to produce screw drivers. 168000 units of metal and 126000 units of plastic are required to produce saws. Mathieu Salmon From the total material required (Y+Z), it is important to add the ending inventory (given data) and to subtract the beginning inventory (given data) in order to get the purchases data in units. Then we have to multiply our results (purchases in units) by the unit costs (given data) in order to find the amount of purchases. The total purchases are also shown. 6) Prepare a budgeted income statement. Screw drivers Per unit Production units Amount 65000 Saws Per unit Amount 42000 Direct material $ 58 $ 3,770,000 $ 47 $ 1,974,000 Direct labor cost $ 24 $ 1,560,000 $ 48 $ 2,016,000 $3 $ 195,000 $ 4.50 $ 189,000 Variable manufacturing OH Variable production cost $ 5,525,000 $ 4,179,000 Total variable production cost $ 9,704,000 Total fixed manufacturing OH $ 214,000 (given) Total manufacturing cost $ 9,918,000 (Income needed) Amount of direct materials= Production units * Direct material per unit (65000*58) Amount of direct labor cost= Production units * Direct labor cost per unit Amount of Variable manufacturing OH= Production units* Variable manufacturing OH per unit 7) Prepare a contribution margin income statement. Screw drivers Selling price (given) Saws $ 100.00 $ 125.00 Direct material $ 58.00 $ 47.00 Direct labor $ 24.00 $ 48.00 $ 3.00 $ 4.50 Less: variable cost Variable overhead (OH) Mathieu Salmon Total variable cost $ 85.00 $ 99.50 Contribution margin (per unit) $ 15.00 $ 25.50 60000 40000 $ 900,000 $ 1,020,000 Units (given) Contribution margin (Total) 8) Prepare a narrative report explaining how the expenses on the income statement were determined. The income statement has been prepared on the basis of the fixed costs and the variable costs that are associated with the production of goods/services in the company. The variable costs include the direct material costs, direct labor costs and also the variable overhead, OH. It is important to remember that the variable overhead costs change depending on the firm’s level of production. However, the fixed cost associated with the production will be incurred and does not vary. The manufacturing cost includes both the fixed and variable cost where the variable cost is calculated depending on the number of units to be produced. Amount of direct materials= Production units * Direct material per unit (65000*58) Amount of direct labor cost= Production units * Direct labor cost per unit (65000*24) Amount of Variable manufacturing OH= Production units* Variable manufacturing OH per unit The total manufacturing cost (income needed) is found by adding the total fixed manufacturing OH to the total variable production cost. On the contribution margin income statement, the contribution margin per unit is found by subtracting the total variable cost from the selling price. Multiplying the contribution margin per unit by the number of units (given) gives the total contribution margin. 9) Prepare a cash budget. Amount Beginning cash (given) Add: Inflows $ 1,800,000 Mathieu Salmon Current year sales (50%) $ 5,500,000 Previous year sales (50%) $ 4,200,000 Less: Outflows Purchase of direct material $ 5,744,000 Payment of direct labor $ 3,576,000 Variable overhead expenses $ 384,000 Fixed manufacturing overhead (OH) $ 58,000 Selling and administration expenses $ 250,000 Cash Balance $ 1,488,000 10) Prepare a narrative report explaining your cash budget process. The cash budget is prepared depending on the inflows and outflows from the production’s activity. The cash inflows include amounts for the current period and the previous period. The current year sales are calculated from 50% * 11,000,000. 11,000,000 are the total sales for both products. The previous year sales are calculated as 50% * 8,400,000. Purchase of Direct materials: 3,770,000+ 1,974,000 Payment of Direct labor: 1,560,000+ 2,016,000 Variable OH expenses: 195000 + 189000 The Fixed manufacturing overhead includes $156000 as the non-cash expenditure. Therefore, it will be reduced from the total expenditure of $214000. The selling and administration expenses include depreciation of $90000, so it will also be deducted from the total expenditure of $340000. The final cash balance is found by adding the cash inflows to the beginning cash given and deducting the cash outflows. 11) If necessary, prepare a capital expenditure budget. Explain your entries. Use only the facts in this case to prepare the budget. The case does not provide information in relation to the capital expenditure involved in the project so the capital expenditure cannot be prepared. Moreover, there is no start of a new project, so there is no need to prepare the capital expenditure budget. The same production process is only being continued and so it is all about forecasting the data for the next quarter. Mathieu Salmon MBAi 6691 Financial/Managerial Accounting for International Executive Case Student: Mario Silva Professor: Dr. Stanley Lewis 1. Statement showing SALES BUDGET: Particulars Screw Driver Saws Units 60000 40000 Selling Price per unit $ 100 $ 125 $ 6,000,000 $ 5,000,000 Total Sales Total Sales $ 11,000,000 2. The above Sales budget is prepared on the basis of the previous sales of the product in the year 2012. The company is selling two products screwdrivers and saws. The sales budget is prepared on the basis of the average sales of the previous period and the budgeted price is also calculated on the basis of the price in the previous periods. The basis of the previous periods provides the best estimate for forecasting the future data. 3. The production budget will be prepared depending upon the sales, opening inventory and the closing inventory Statement showing PRODUCTION BUDGET (in units): Particulars Screw Driver Saws Sales 60000 40000 Add: Closing Stock 25000 10000 Less: Opening Stock 20000 8000 Production 65000 42000 1 4. Statement showing PURCHASE BUDGET: Particulars Metal Plastic Handle SCREW DRIVERS Production (in units) 65000 65000 65000 5 3 1 325000 195000 65000 42000 42000 - 4 3 - Material Required (B) 168000 126000 - Total Material Required (A+ B) 493000 321000 65000 Add: Closing Balance 36000 32000 7000 Less: Opening Balance 32000 29000 6000 497000 324000 66000 $8 $5 $3 $ 3,976,000 $ 1,620,000 $ 198,000 Material required p.u. Material Required (A) SAWS Production (in units) Material required p.u. Purchases (in units) Purchase price per unit Purchases Total Purchases $ 5,794,000 5. The purchase budget is being prepared depending upon the production budget of the screwdrivers and the saws. The purchase budget is being prepared keeping in view the opening inventory available with the company and the closing inventory available with the company. Adding sales and closing stock of the materials and deducting the opening stock of the materials will calculate the purchase quantity. The quantity of material to be required for producing the required quantities is added to the closing stock of materials and deducting the opening stock of materials. 2 6. Statement showing MANUFACTURING COST BUDGET: Particulars Screw Driver Per Unit Production Units Amount Saws Per unit 65000 Amount 42000 Direct Material $ 58 $ 3,770,000 $ 47 $ 1,974,000 Direct Labor Cost $ 24 $ 1,560,000 $ 48 $ 2,016,000 $3 $ 195,000 $ 4.50 $ 189,000 Variable Manufacturing OH Variable Production Cost $ 5,525,000 $ 4,179,000 Total Variable Production Cost $ 9,704,000 Total Fixed Manufacturing OH $ 214,000 Total Manufacturing Cost $ 9,918,000 7. Statement showing CONTRIBUTION MARGIN INCOME STATEMENT: Particulars Screw Driver Selling Price Saws $ 100.00 $ 125.00 Direct Material $ 58.00 $ 47.00 Direct Labor $ 24.00 $ 48.00 Variable Overhead $ 3.00 $ 4.50 Total Variable Cost $ 85.00 $ 99.50 Contribution Margin p.u. $ 15.00 $ 25.50 60000 40000 $ 900,000 $ 1,020,000 Less: Variable Cost Units Contribution Margin 8. The income was prepared on the basis of the variable costs and the fixed costs that are associated with the production of goods in the company. The variable cost comprises the direct material cost, direct labor cost and the variable overheads, which change with the changes in the level of production. There is fixed cost also which is associated with the production and this cost will be incurred irrespective of the production. Thus the manufacturing cost comprises both the variable and the fixed 3 cost. The variable cost is being calculated depending on the units to be produced and the per unit rates specified. 9. Statement showing CASH BUDGET: Particulars Amount Opening Cash Balance $ 1,800,000 Add: Inflows Current Year Sales $ 5,500,000 Previous Year Sales $ 4,200,000 Less: Outflows Purchase of Direct Material $ 5,794,000 Payment of Direct Labor $ 3,576,000 Variable Overhead Expenses $ 384,000 Fixed Manufacturing Overhead Selling and administration overhead Closing Cash Balance $ 58,000 $ 250,000 $ 1,438,000 10. The cash budget is being calculated depending on the inflows and outflows from the production activity. The inflows include amounts both for the current period and the previous period. The amounts for the current period are calculated as 50%* 11000000. The amount for the previous period is being calculated as 50%*8400000. The Direct material, direct labor and the variable overhead cost are paid in the same quarter and thus include the cost of both the goods and the Fixed manufacturing overhead includes $ 156000 as the non-cash expenditure thus, it will be reduced from the total expenditure of $214000. The selling and administration overhead includes depreciation of $90000 thus it will also be deducted from the total expenditure of $340000. Thus, adding the cash inflows to the opening balance and deducting the cash outflows will calculate the closing cash balance. 4 11. The capital expenditure cannot be prepared as no information is being provided in relation to the capital expenditure involved in the project and according to me there is no need to prepare the capital expenditure budget as no new project is started. The same production process is being continued and thus it is mere forecasting of the data for the coming quarter. 5
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
This is great! Exactly what I wanted.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags