N.B: I don’t need the attachment of excel file. Just the snap of excel with “show formula” will be good. Please help me with this. Beta Products Ltd. has just created a new division to manufacture and sell a fitness tracker. The facility ishighly automated and has high monthly fixed costs, as shown in the following schedule of budgeted monthlycosts. This schedule was prepared based on an expectation of a monthly production volume of 1,350 units.Manufacturing costs:$20Direct materials per unitDirect manufacturing labour per unitVariable manufacturing overhead per unitTotal fixed manufacturing overhead$15$10$54,000 per monthMarketing costs:6% of salesVariable marketingTotal fixed marketing overhead$52,000 per monthThe selling price per unit is $180.The following activity was recorded:OctoberNovember1,200Units producedUnits sold1,5001,1001,450REQUIRED: RequiredIn Excel, create a solution with one excel tab labelled “Actual" and one tab labelled "Standard". (Do NOT usemy spreadsheets.) All cells on the income statement MUST be linked to the raw data that is shown at the top ofeach spreadsheet. Your solution needs to have the following items in the following order:The tab called "ACTUAL" MUST contain:a.Raw data for units and all costs for ACTUAL costing AT THE TOP OF THE SPREADSHEET.b. Variable costing (contribution margin) income statement using ACTUAL costing for October andNovember.c. Absorption costing (gross margin) income statement using ACTUAL costing for October andNovember.The tab called "STANDARD" MUST contain:d. Raw data for units and all costs for STANDARD costing AT THE TOP OF THE SPREADSHEET.e. Variable costing (contribution margin) income statement using STANDARD costing for October andNovember.f. Absorption costing (gross margin) income statement using STANDARD costing for October andNovember.The raw data for your question is on the following page. You can use any reference material as it is openbook. However, discussions need to be kept between you and your partner.

Answered: Image /qna-images/answer/10af50b4-1689-4111-99bb-690f97022db0.jpg

Beta Products Ltd. has just created a new division to manufacture and sell a fitness tracker. The facility is highly automated and has high monthly fixed costs, as shown in the following schedule of budgeted monthly costs. This schedule was prepared based on an expectation of a monthly production volume of 1,350 units. Manufacturing costs: $20 Direct materials per unit Direct manufacturing labour per unit Variable manufacturing overhead per unit Total fixed manufacturing overhead $15 $10 $54,000 per month Marketing costs: 6% of sales Variable marketing Total fixed marketing overhead $52,000 per month The selling price per unit is $180. The following activity was recorded: October November 1,500 1,100 1,200 1,450 Units produced Units sold REQUIRED: I.

Beta Products Ltd. has just created a new division to manufacture and sell a fitness tracker. The facility is highly automated and has high monthly fixed costs, as shown in the following schedule of budgeted monthly costs. This schedule was prepared based on an expectation of a monthly production volume of 1,350 units. Manufacturing costs: $20 Direct materials per unit Direct manufacturing labour per unit Variable manufacturing overhead per unit Total fixed manufacturing overhead $15 $10 $54,000 per month Marketing costs: 6% of sales Variable marketing Total fixed marketing overhead $52,000 per month The selling price per unit is $180. The following activity was recorded: October November 1,500 1,100 1,200 1,450 Units produced Units sold REQUIRED: I.

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 4CMA: Krouse Company produces two products, forged putter heads and laminated putter heads, which are sold...

See similar textbooks

Similar questions

Hatch Manufacturing produces multiple machine parts. The theoretical cycle time for one of its products is 65 minutes per unit. The budgeted conversion costs for the manufacturing cell dedicated to the product are 12,960,000 per year. The total labor minutes available are 1,440,000. During the year, the cell was able to produce 0.6 units of the product per hour. Suppose also that production incentives exist to minimize unit product costs. Required: 1. Compute the theoretical conversion cost per unit. 2. Compute the applied conversion cost per minute (the amount of conversion cost actually assigned to the product). 3. Discuss how this approach to assigning conversion cost can improve delivery time performance. Explain how conversion cost acts as a performance driver for on-time deliveries.
Krouse Company produces two products, forged putter heads and laminated putter heads, which are sold through specialty golf shops. The company is in the process of developing itsoperating budget for the coming year. Selected data regarding the companys two products areas follows: Manufacturing overhead is applied to units using direct labor hours. Variable manufacturing overhead Ls projected to be 25,000, and fixed manufacturing overhead is expected to be15,000. The estimated cost to produce one unit of the laminated putter head is: a. 42. b. 46. c. 52. d. 62.
Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.
Firenza Company manufactures specialty tools to customer order. Budgeted overhead for the coming year is: Previously, Sanjay Bhatt, Firenza Companys controller, had applied overhead on the basis of machine hours. Expected machine hours for the coming year are 50,000. Sanjay has been reading about activity-based costing, and he wonders whether or not it might offer some advantages to his company. He decided that appropriate drivers for overhead activities are purchase orders for purchasing, number of setups for setup cost, engineering hours for engineering cost, and machine hours for other. Budgeted amounts for these drivers are 5,000 purchase orders, 500 setups, and 2,500 engineering hours. Sanjay has been asked to prepare bids for two jobs with the following information: The typical bid price includes a 40 percent markup over full manufacturing cost. Required: 1. Calculate a plantwide rate for Firenza Company based on machine hours. What is the bid price of each job using this rate? 2. Calculate activity rates for the four overhead activities. What is the bid price of each job using these rates? 3. Which bids are more accurate? Why?
Gent Designs requires three units of part A for every unit of Al that it produces. Currently, part A is made by Gent, with these per-unit costs in a month when 4.000 units were produced: Variable manufacturing overhead is applied at $1.00 per unit. The other $0.30 of overhead consists of allocated fixed costs. Gent will need 6,000 units of part A for the next years production. Cory Corporation has offered to supply 6,000 units of part A at a price of $7.00 per unit. It Gent accepts the offer, all of the variable costs and $1,200 of the fixed costs will be avoided. Should Gent Designs accept the offer from Cory Corporation?
Sunrise Poles manufactures hiking poles and is planning on producing 4,000 units in March and 3,700 in April. Each pole requires a half pound of material, which costs $1.20 per pound. The companys policy is to have enough material on hand to equal 10% of the next months production needs and to maintain a finished goods inventory equal to 25% of the next months production needs. What is the budgeted cost of purchases for March?
Computador has a manufacturing plant in Des Moines that has the theoretical capability to produce 243,000 laptops per quarter but currently produces 91,125 units. The conversion cost per quarter is 7,290,000. There are 60,750 production hours available within the plant per quarter. In addition to the processing minutes per unit used, the production of the laptops uses 10 minutes of move time, 20 minutes of wait time, and 5 minutes of rework time. (All work is done by cell workers.) Required: 1. Compute the theoretical and actual velocities (per hour) and the theoretical and actual cycle times (minutes per unit produced). 2. Compute the ideal and actual amounts of conversion cost assigned per laptop. 3. Calculate MCE. How does MCE relate to the conversion cost per laptop?
Uchdorf Manufacturing just completed a study of its purchasing activity with the objective of improving its efficiency. The driver for the activity is number of purchase orders. The following data pertain to the activity for the most recent year: Activity supply: five purchasing agents capable of processing 2,400 orders per year (12,000 orders) Purchasing agent cost (salary): 45,600 per year Actual usage: 10,600 orders per year Value-added quantity: 7,000 orders per year Required: 1. Calculate the volume variance and explain its significance. 2. Calculate the unused capacity variance and explain its use. 3. What if the actual usage drops to 9,000 orders? What effect will this have on capacity management? What will be the level of spending reduction if the value-added standard is met?
Nashler Company has the following budgeted variable costs per unit produced: Budgeted fixed overhead costs per month include supervision of 98,000, depreciation of 76,000, and other overhead of 245,000. Required: 1. Prepare a flexible budget for all costs of production for the following levels of production: 160,000 units, 170,000 units, and 175,000 units. 2. What is the per-unit total product cost for each of the production levels from Requirement 1? (Round each unit cost to the nearest cent.) 3. What if Nashler Companys cost of maintenance rose to 0.22 per unit? How would that affect the unit product costs calculated in Requirement 2?
Cloud Shoes manufactures recovery sandals and is planning on producing 12.000 units in March and 11,500 in April. Each sandal requires 1.2 yards if material, which costs $3.00 per yard. The companys policy is to have enough material on hand to equal 15% of next months production needs and to maintain a finished goods inventory equal to 20% of the next months production needs. What is the budgeted cost of purchases for March?
Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: Four welding units, with a lease cost of 12,000 per year per unit Six welding employees each paid a salary of 50,000 per year (A total of 9,000 welding hours are supplied by the six workers.) Welding supplies: 300 per job Welding hours: Three hours used per job During the year, the activity operated at 90 percent of capacity and incurred the actual activity and resource costs, shown on page 676. Lease cost: 48,000 Salaries: 315,000 Parts and supplies: 805,000 Required: 1. Prepare a flexible budget formula for the welding activity using welding hours as the driver. 2. Prepare a performance report for the welding activity. 3. What if welders were hired through outsourcing and paid 30 per hour (the welding equipment is provided by Foy)? Repeat Requirement 1 for the outsourcing case.
Douglas Davis, controller for Marston, Inc., prepared the following budget for manufacturing costs at two different levels of activity for 20X1: During 20X1, Marston worked a total of 80,000 direct labor hours, used 250,000 machine hours, made 32,000 moves, and performed 120 batch inspections. The following actual costs were incurred: Marston applies overhead using rates based on direct labor hours, machine hours, number of moves, and number of batches. The second level of activity (the right column in the preceding table) is the practical level of activity (the available activity for resources acquired in advance of usage) and is used to compute predetermined overhead pool rates. Required: 1. Prepare a performance report for Marstons manufacturing costs in the current year. 2. Assume that one of the products produced by Marston is budgeted to use 10,000 direct labor hours, 15,000 machine hours, and 500 moves and will be produced in five batches. A total of 10,000 units will be produced during the year. Calculate the budgeted unit manufacturing cost. 3. One of Marstons managers said the following: Budgeting at the activity level makes a lot of sense. It really helps us manage costs better. But the previous budget really needs to provide more detailed information. For example, I know that the moving materials activity involves the use of forklifts and operators, and this information is lost when only the total cost of the activity for various levels of output is reported. We have four forklifts, each capable of providing 10,000 moves per year. We lease these forklifts for five years, at 10,000 per year. Furthermore, for our two shifts, we need up to eight operators if we run all four forklifts. Each operator is paid a salary of 30,000 per year. Also, I know that fuel costs about 0.25 per move. Assuming that these are the only three items, expand the detail of the flexible budget for moving materials to reveal the cost of these three resource items for 20,000 moves and 40,000 moves, respectively. Based on these comments, explain how this additional information can help Marston better manage its costs. (Especially consider how activity-based budgeting may provide useful information for non-value-added activities.)