Question

In: Accounting

24. The Cat & Company Corporation manufactures and sells two products: Thingone and Thingtwo. In July...

24. The Cat & Company Corporation manufactures and sells two products: Thingone and Thingtwo. In July 2013, the corporation’s budget department gathered the following data to prepare budgets for 2014:

2014 Projected Sales:

Product                               Units                     Price

Thingone             62,000 units        $172

Thingtwo             46,000 units        $264

2014 Projected Inventory in Units:

Product                               January 1, 2014 December 31,2014

Thingone                  21,000                                                 26,000

Thingtwo                  13,000                                                 14,000

The following direct materials are used in the two products

Amount Used per Unit

Direct Material                  Unit                       Thingone             Thingtwo

A                             pound                           5                            6

B                             pound                           3                            4

C                             each                              0                            2

Projected data for 2014 for direct materials are:

                                   Anticipated              Expected Inventories           Expected Inventories

Direct Material     Purchase Price              January 1,2014     December 31, 2014

A                             $11                        37,000 lb.                                             40,000 lb.                                 

B                             $6                           37,000 lb.                                             35,000 lb.

C                             $5                           10,000 units                                       12,000 units

Projected direct manufacturing labor requirements and rates for 2014 are:

Product                               Hours per Unit                  Rate per Hour

Thingone                        3                                      $11

Thingtwo                        4                                      $14

Manufacturing overhead is allocated at the rate of $19 per direct manufacturing labor-hour. Based on the preceding projections and budget requirements for Thingone and Thingtwo, answer the following questions:

  1. What is the total projected revenue in dollars?
  2. What are the production requirements for each product?
  3. What is the direct material purchases budget in quantities?
  4. What is the direct material purchases budget in dollars?
  5. What is the direct manufacturing labor budget in dollars?
  6. What is the budgeted finished goods inventory at December 31,2014 in dollars?

Solutions

Expert Solution

Please feel free to comment in case of any query. Please upvote.


Related Solutions

A Company manufactures and sells two products: A and B. The following table shows the information...
A Company manufactures and sells two products: A and B. The following table shows the information relating to these products: A B Total Selling price per unit $20 $40 Variable cost per unit $10 $20 Total Fixed costs $80,000 Required: If Sales mix is 2 :3 for A and B respectively, calculate the breakeven point in units and in dollars for each of the two products.
A Company is selling two products A and B. It sells the two products at the...
A Company is selling two products A and B. It sells the two products at the prices of AED 190 and 230 respectively. The finance department estimated the fixed cost for both products A and B as AED 2400 and 2550 and the variable cost to make a unit of each product is AED 70 and 60 respectively. Compute the number of units the company must sell to Break-Even from each product? Compute the total revenue at these Break-Even Points?...
A & B manufactures and sells two types of products to a number of customers. The...
A & B manufactures and sells two types of products to a number of customers. The resources are as follows: Material Type Product X Product Y Available Material P 8 10 31,250 Material Q 10 5 20,000 Direct Labour 4 5 17,500 Maximum sales(demand) for X is 1000 units and Y 3000 units.Contribution margin X $96 and Y $110 Formulate a linear programme Solve in excel Write a brief report to explain the analysis
Fancy Foot Cat Biscuits Company manufactures cat treats. The company has the following actual data for...
Fancy Foot Cat Biscuits Company manufactures cat treats. The company has the following actual data for January and February 20xx.                                                                           January                                                                                  February Beginning inventory in kilograms                          0                                                                                             2,000 Production in kilograms                                   20,000                                                                                        20,000 Sales in kilograms                                          18,000                                                                                         21,000 Variable manufacturing costs per unit produced  $8                                                                                             $8 Variable marketing costs per unit sold                $2                                                                                              $2 Fixed manufacturing costs                            $30,000                                                                                     $30,000 Fixed marketing costs                                    $5,000                                                                                         $5,000 The selling price per kilogram is $20.00. The budgeted level of production used to calculate the budgeted fixed...
Nutrition Corporation manufactures and sells healthy foods products online to consumers and delivers the products ordered...
Nutrition Corporation manufactures and sells healthy foods products online to consumers and delivers the products ordered online by shipping the goods directly to customers in all 50 states. Nutrition does not have a brick-and-mortar store presence in any state, but does operate distribution centers in various states across the country, including Virginia. Consistent with its practice in all 50 states, Nutrition does not collect or remit sales tax to Virginia. In recent court rulings, the state of Virginia has taken...
A company manufactures and sells two products: Product A1 and Product C4. Data concerning the expected...
A company manufactures and sells two products: Product A1 and Product C4. Data concerning the expected production of each product and the expected total direct labor-hours (DLHs) required to produce that output appear below: Expected Production Direct Labor-Hours Per Unit Total Direct Labor-Hours Product A1 300 4.0 1,200 Product C4 600 2.0 1,200 Total direct labor-hours 2,400 The direct labor rate is $25.90 per DLH. The direct materials cost per unit is $285 for Product A1 and $244 for Product...
A company manufactures and sells two products: Product A1 and Product C4. Data concerning the expected...
A company manufactures and sells two products: Product A1 and Product C4. Data concerning the expected production of each product and the expected total direct labor-hours (DLHs) required to produce that output appear below: Expected Production Direct Labor-Hours Per Unit Total Direct Labor-Hours Product A1 100 2.0 200 Product C4 200 1.0 200 Total direct labor-hours 400 The direct labor rate is $29.70 per DLH. The direct materials cost per unit is $263 for Product A1 and $266 for Product...
Weirick, Inc., manufactures and sells two products: Product T8 and Product P4. The company has an...
Weirick, Inc., manufactures and sells two products: Product T8 and Product P4. The company has an activity-based costing system with the following activity cost pools, activity measures, and expected activity   Expected Activity Activity Cost Pools   Activity Measures Estimated Estimated Cost Product T8   Product P4 Total   Labor-related   DLHs $127,500 3,600   1,800 5,400 Production orders Orders 60,110 700 400 1,1004 Order size MHs 940,160   4,000 3,100    7,100 Total: $ 1,127,770 The total overhead applied to Product P4 under activity-based costing is...
Henna Co. produces and sells two products, T and O. It manufactures these products in separate...
Henna Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company sold 43,000 units of each product. Sales and costs for each product follow. Product T Product O Sales $ 761,100 $ 761,100 Variable costs 608,880 76,110 Contribution margin 152,220 684,990 Fixed costs 33,220 565,990 Income before taxes 119,000 119,000 Income taxes (30% rate) 35,700 35,700 Net income $...
Letter Co. produces and sells two products, T and O. It manufactures these products in separate...
Letter Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company sold 48,000 units of each product. Sales and costs for each product follow. Product T Product O   Sales $ 825,600 $ 825,600   Variable costs 577,920 165,120   Contribution margin 247,680 660,480   Fixed costs 113,680 526,480   Profit before taxes 134,000 134,000   Income taxes (32% rate) 42,880 42,880   Net profit $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT