Hoping you can help me answer these questions

Thanks!!

Cost Management Assignment #3 15% of Final Grade Chapters 6 & 7- 50 Marks This Assignment has 4 Questions. Answer all questions using Microsoft Word. Very Important Instructions How to save and submit your completed assignment: 1. 2. 3. 4. 5. 6. Put your answers in a separate word document. Submit the answers only. I.E. Do not resubmit the question. Submit answers in Micro Soft Word document. For the true false and multiple choice questions, list in column format, the number of the question followed by the one best answer. No marks awarded for explanation or calculations for true and false or the multiple choice questions. Completed assignment to be uploaded to the \"Assignment #3 Submission\" area posted under Week 10. Ensure that you upload the correct file as you only have one attempt to upload your assignment. The file uploaded will be the one that is graded. Unreadable or unattached files are considered a non submission. Late assignments will not be accepted. File Naming: 1. Assign the file name in the following manner: Student last name, first Name Ass # 2. Also you must place you full name on the top of the word document 3. Note: There is a 10% deduction on each submission when these instructions are not followed. File Uploading Instructions 1. Open the Submit Assignment 3 icon and upload your completed assignment. 2. Use the Browse button at the bottom of the page to select your Word document for uploading 3. Click Upload 1 Question #1 ACTIVITY-BASED COSTING (20 marks) Markham Inc. designs and builds custom windows for luxury homes. Most of the windows are custom made but occasionally the company does mass production on order. Its budgeted manufacturing overhead costs for the year 2006 are as follows: Overhead Cost Pools Purchasing Production (cutting, milling, finishing) Setting up machines Inspecting Utilities Total budget overhead costs Amount $ 180,000 400,000 135,000 160,000 300,000 $1,175,000 For the last three years, the company has been charging overhead to products on the basis of machine hours. For the year 2006, 100,000 machine hours are budgeted. Tommy Barry, owner-manager of Markham Inc. recently directed her accountant to implement the activity-based costing system she has repeatedly proposed. At Tommy's request, the accountant and production foreman identify the following cost drivers and their usage for the previously budgeted overhead cost pools. Overhead Cost Pools Purchasing Production (cutting, milling, finishing) Setting up machines Inspecting Utilities Activity Cost Drivers Number of orders Direct labour hours Number of setups Number of inspections Square metres occupied Total Drivers 500 80,000 1,000 5,000 75,000 During this month, the company received an order for 50 window sets from a housing development contractor. The accountant prepares cost estimates for producing components for 50 window sets so Tommy can submit a contract price per window set to the contractor. The following data for the production of 50 window sets is accumulated: Direct materials Direct labour Machine hours Direct labour hours Number of purchase orders Number of machine setups Number of inspections Number of square metres occupied $120,000 $135,000 12,000 10,000 50 80 380 7,000 Instructions: (a) Calculate the predetermined overhead rate using traditional costing with machine hours as the basis. (2 marks) (b) Calculate the manufacturing cost per window set under traditional costing. (6 marks) (c) Calculate the manufacturing cost per window set under the proposed activity-based costing. (12 marks) 2 Question #2 ACTIVITY BASED COSTING (5 marks) Cummings Company has identified the following overhead activities costs and activity drivers for the coming year: Activity Setting up Inspecting Grinding Receiving Expected cost $120,000 $ 90,000 $180,000 ? Activity Driver Number of setups Inspection hours Machine hours Number of parts Activity Capacity 600 9,000 36,000 100,000 The company produces several different subassemblies used by other manufacturers. Information on separate batches for two of these subassemblies follows: F Direct Materials $ 1,700 Direct Labour $ 1,200 Units Completed 200 Number of setups 2 Inspection hours 8 Machine hours 40 Parts used 40 G $1,900 $ 1,200 100 2 4 60 80 The company's normal activity is 20,000 direct labour hours. Each batch uses 100 hours of direct labour. Upon investigation, you discover that Receiving employs a worker, who spends 75% of her time on the receiving activity and 25% of her time on inspecting products. Her salary is $80,000. Receiving also uses a forklift, at a cost of $12,000 per year for amortization and fuel. The forklift is used only in receiving. Instructions: a) What is the amount of cost assigned to the receiving activity? (3 marks) b) What is the activity rate for receiving? (2 marks) Question #3 MULTIPLE CHOICE (10 marks) 3 Instructions: Designate the best answer for each of the following questions. ___ 1. Looker Hats is planning to sell 600 felt hats, and 700 will be produced during June. Each hat requires metre of felt and hour of direct labour. Felt costs $3.00 per metre and employees of the company are paid $20 per hour. How much is the total amount of budgeted direct labour for June? a. $3,000 b. $48,000 c. $3,500 d. $2,400 ____ 2. Orr Corporation's manufacturing costs for August when production was 800 units appears below: Direct material $10 per unit Direct labour $4,800 Variable overhead 4,000 Factory amortization 3,000 Factory supervisory salaries 2,000 Other fixed factory costs 1,000 How much is the budgeted manufacturing cost for a month when 900 units are produced? a. $23,800 b. $18,900 c. $24,900 d. $25,650 ____ 3. Lewis Production is planning to sell 220 boxes of bricks and produce 200 boxes of bricks during May. Each box of bricks requires 20 kilograms of brick mix and a half hour of direct labour. Brick mix costs $5 per 100 kilograms and employees of the company are paid $12.00 per hour. Manufacturing overhead is applied at a rate of 120% of direct labour costs. Lewis Production has 600 kilograms of brick mix in beginning inventory and wants to have 800 kilograms of brick mix in ending inventory. What is the total amount to be budgeted for manufacturing overhead for the month? a. $1,440 b. $2,880 c. $2,400 d. $1,200 ____ 4. Hargrow, Inc. makes and sells a single product, buckets. It takes 30 ounces of plastic to make one bucket. Budgeted production of buckets for the next three months is as follows: August 90,000 units, September 75,000 units, October 65,000 buckets. The company wants to maintain monthly ending inventories of plastic equal to 10% of the following month's production needs. On August 31 st, 195,000 ounces of plastic were on hand. The cost of plastic is $0.03 per ounce. How much is the ending inventory of plastic to be reported on the company's balance sheet at September 30? a. $195,000 b. $5,850 c. $6,750 4 d. $7,500 ____ 5. Razmataz Company makes and sells umbrellas. The company is in the process of preparing its Selling and Administrative Expense Budget for the last half of the year. The following budget data are available: Item Sales commissions Shipping Advertising Amortization on office equipment Other operating expenses Variable Cost Per Unit Sold $0.60 $1.20 $0.30 Monthly Fixed Cost $3,000 $4,000 $0.35 $34,000 Expenses are paid in the month incurred. If the company has budgeted to sell 2,000 umbrellas in October, how much is the total budgeted variable selling and administrative expenses for October? a. $41,000 b. $4,600 c. $45,900 d. $4,900 ____ 6. Grant Company estimates its sales at 80,000 units in the first quarter and that sales will increase by 8,000 units each quarter over the year. They have, and desire, a 25% ending inventory of finished goods. Each unit sells for $25. 40% of the sales are for cash. 70% of the credit customers pay within the quarter. The remainder is received in the quarter following sale. Cash collections for the third quarter are budgeted at a. $1,356,000. b. $1,968,000. c. $2,364,000. d. $2,736,000. ____ 7. At January 1, 2006, Jake, Inc. has beginning inventory of 3,000 surfboards. Jake estimates it will sell 14,000 units during the first quarter of 2006 with a 10% increase in sales each quarter. Jake's policy is to maintain an ending inventory equal to 20% of the next quarter's sales. Each surfboard costs $140 and is soldfor $200. How many units should Jake produce during the first quarter of 2006? a. 14,080 b. 14,000 c. 16,800 d. 14,200 5 ____ 8. Nunnally Manufacturing Company has furnished the following information which occurred during May: Accounts Payable balance at April 30 Purchases on account during May Cash payments for materials purchased in April Cash payments for materials purchased in May $ 29,000 150,000 29,000 135,000 The accounts payable account is used only for direct materials. How much will Nunnally report as accounts payable on the balance sheet at the end of May? a. $21,000 b. $103,000 c. $8,000 d. $15,000 ____ 9. Harrah Company provided the following information for the month of October: Beginning cash balance Cash receipts Cash disbursements $ 35,000 460,000 485,000 Harrah's policy is to keep a minimum end of the month cash balance of $30,000. How much will Harrah's need to borrow during October? a. b. c. d. ____10. $20,000 $25,000 $10,000 $0 Each production worker can produce 4 wooden chairs per hour. During the month of June, Chairs, Inc. has forecasted sales of 100,000 chairs. The beginning inventory was 10,000 chairs, and desired ending inventory is 2,500 chairs. How many hours of direct labour must be budgeted to meet production needs? a. 25,375 b. 25,000 c. 23,125 d. 24,625 6 Question #4 SALES AND PRODUCTION BUDGET (15 marks) Jennings Corporation manufactures two models of tires: XL and DL. Instructions: Based on the following production and sales data for August 2006, prepare (a) a sales budget (b) a production budget. Estimated inventory, August 1 Desired inventory, August 31 Expected sales in units Unit sales price XL 350 375 7,500 $150 DL 150 125 5,200 $130 7