Question

In: Accounting

Cost Classification: The Lee’s have provided you with the following costs and relevant information that are...

  1. Cost Classification: The Lee’s have provided you with the following costs and relevant information that are assumed for year 20XY.

A. Classify each of the costs (a. through j.) below under C. as a variable cost or a fixed cost.

B. Explain the importance of distinguishing between variable and fixed costs.

C. Prepare a budgeted income statement, assuming 600 units to be produced and sold, a per unit selling price of $85, an income tax rate of 28% and the following information.

  1. Cost of goods sold of $35 per unit
  2. Labor = $400/month
    • One part-time employee will be hired to take care of packaging and shipping. This employee will be paid $10 per hour. He or she is estimated to work 40 hours total per month.
  3. Advertising fees = $3,000
  4. Bank fees = $200
  5. Phone/internet = $150 per month
  6. Shipping = $3 per unit
  7. Utilities = $100 per month
  8. Office Supplies = $900
  9. Conference Exhibitor Fee = $3000
  10. Travel Expenses for Conference (e.g. airfare, meals, taxi) = $1200

2. Budget Preparation: The Lees believe that production and sales could double after being on Shark Tank which is scheduled in December of 20XY. They want to be prepared for this. Based on the budgeted income statement calculated above for 20XY, create a new budgeted income for 20XZ assuming that the production and sales is double the level of 20XY.

Solutions

Expert Solution

A In order to take decisions under different situations, costs are classified into two groups. They are-
1. Fixed cost. It does not change with the change in quantity produced. Rent of a house is contractually fixed. So it is a fixed cost.
2. Variable cost: It directly changes with output. Usually per unit variable cost is fixed. It is multiplied by quantity to get total variable cost
Some costs are partly fixed partly variable in nature. They are discussed below:
1. Cost of goods sold: It is $35 per unit. As per unit cost is fixed, total cost of goods will depend upon quantity produced. If production is 600 units then total cost of goods sold is-
$35*600 units $21,000
2. Labor cost is 400 per month. as it is contractually fixed, it is a fixed cost.
3. Part time labor: He is paid on hourly basis. Rate is $10 per hour. He is expected to work for 40 hours in a month. So he is paid a constant amount $10x40=$400. Hence it is also fixed cost.
4. Advertising: It is $3,000 per month. So it does not depend upon quantity produced and sold. Hence it is fixed cost.
5. Bank fees: it is also fixed at $200 per month. So it is a fixed cost.
6. Phone and internet: it is also fixed at $150 per month.
7. Shipping : It is $3 per unit. So it will change with the quantity. It is variable. For 600 units total shipping cost is-
$3*600 units $1,800
8. Utilities: It is also fixed at $100 per month
9. Office supplies is fixed at $900 per month.
10. Conference exhibitors fees is fixed. Amount is $3000.
11. Travel: it is also fixed at $1200.
B This classification is vary crucial in decision making purpose. Many decisions, like buy or sale, close down of a department, optimum product mix etc are taken on the basis of fixed and variable cost differentiation. Also budget preparation requires consideration of the fixed and variable separately.
C Budgeted income statement for a month is shown below-
Details Amount Amount
1. Quantity produced and sold 600 units
2. Sale @ 85 per unit [$85x600 units] $51,000
3. Cost of goods sold [$35x600 units] $21,000
4. Gross profit : [2-3] $30,000
5. Other variable cost :
-Shipping @$3 per unit [3x600] $1,800 $1,800
6.total contribution [4-5] $28,200
7. Total fixed cost-   i
-labor $400
-Casual labor $400
-Advertising $3,000
-Bank fees $200
-Phone/internet $150
-utilities $100
-Office supplies $900
-Conference exhibitors fees $3,000
-Travel expense $1,200
Total fixed cost $9,350
8. Net profit [7-8] $18,850
9. Income tax 28% on 8. $5,278
10. Profit after tax [8-9] $13,572
2 create a new budgeted income for 20XZ assuming that the production and sales is double the level of 20XY.
Details Amount Amount
1. Quantity produced and sold 1200 units
2. Sale @ 85 per unit [$85x1200 units] $102,000
3. Cost of goods sold [$35x1200 units] $42,000
4. Gross profit : [2-3] $60,000
5. Other variable cost :
Shipping @$3 per unit [3x1200] $3,600 $3,600
6.Total contribution [4-5] $56,400
7. Total fixed cost-   i
-labor $400
-Casual labor $400
-Advertising $3,000
-Bank fees $200
-Phone/internet $150
-utilities $100
-Office supplies $900
-Conference exhibitors fees $3,000
-Travel expense $1,200
Total fixed cost $9,350
8. Net profit [7-8] $47,050
9. Income tax 28% on 8. $13,174
10. Profit after tax [8-9] $33,876

Related Solutions

Cost Classification: The Lee’s have provided you with the following costs and relevant information that are...
Cost Classification: The Lee’s have provided you with the following costs and relevant information that are assumed for year 20XY. A. Classify each of the costs (a. through j.) below under C. as a variable cost or a fixed cost. B. Explain the importance of distinguishing between variable and fixed costs. C. Prepare a budgeted income statement, assuming 600 units to be produced and sold, a per unit selling price of $85, an income tax rate of 28% and the...
Cost Classification: The Lee’s have provided you with the following costs and relevant information that are...
Cost Classification: The Lee’s have provided you with the following costs and relevant information that are assumed for year 20XY. A. Classify each of the costs (a. through j.) below under C. as a variable cost or a fixed cost. B. Explain the importance of distinguishing between variable and fixed costs. C. Prepare a budgeted income statement, assuming 600 units to be produced and sold, a per unit selling price of $85, an income tax rate of 28% and the...
3.        Cost Classification: The Lee’s have provided you with the following costs and relevant information that are...
3.        Cost Classification: The Lee’s have provided you with the following costs and relevant information that are assumed for year 20XY. A. Classify each of the costs (a. through j.) below under C. as a variable cost or a fixed cost. B. Explain the importance of distinguishing between variable and fixed costs. C. Prepare a budgeted income statement, assuming 600 units to be produced and sold, a per unit selling price of $85, an income tax rate of 28% and the...
Please complete in Excel document with correct formulas and attach. Cost Classification: The Lee’s have provided...
Please complete in Excel document with correct formulas and attach. Cost Classification: The Lee’s have provided you with the following costs and relevant information that are assumed for year 20XY. A. Classify each of the costs (a. through j.) below under C. as a variable cost or a fixed cost. B. Explain the importance of distinguishing between variable and fixed costs. C. Prepare a budgeted income statement, assuming 600 units to be produced and sold, a per unit selling price...
Which of the following is the cost of quality classification for costs, such as scrap or...
Which of the following is the cost of quality classification for costs, such as scrap or rework, that occur before a product is shipped to a customer? Group of answer choices A) Appraisal costs B) Prevention costs C) External failure costs D) Internal failure costs E) Rework and wastage PreviousNext
Willow Designs have provided you with the following relevant information: Desired ending inventory 2019      $= 45,673 Expected...
Willow Designs have provided you with the following relevant information: Desired ending inventory 2019      $= 45,673 Expected sales 2019        $= 382,038 Opening inventory 2019      $= 41,498 Cost of goods sold is 45% of budgeted sales On the basis of the information provided, calculate the total budgeted purchases for 2019 (rounded to the nearest dollar)
Please complete the LIFO information with the information provided. (Not all information provided may be relevant...
Please complete the LIFO information with the information provided. (Not all information provided may be relevant in completing the question). Inventory Information Inventory on hand at the beginning of October: Units Cost / unit Total Cost Purchase # 1 15 60 $900 Purchase # 2 25 70 1,750 40 $2,650 October 2018 transactions related to buying and selling widget inventory 3-Oct Purchased 60 widgets at a cost of $80 per widget on credit 10-Oct Sold 45 widgets at $150 each...
Which of the following is the cost of quality classification for costs incurred to improve process...
Which of the following is the cost of quality classification for costs incurred to improve process reliability or reduce process variation? a. rework and wastage b. external failure costs c. internal failure costs d. appraisal cost e. prevention cost
Magdalena have provided you with the following information in the table and you are required to...
Magdalena have provided you with the following information in the table and you are required to find the value of the below bond to assist her with her investment decision: Cash Flow Appropriate required return End of year Amount 1 3,000.00 2.1% 2 3,000.00 3 3,000.00 4 53,000.00
Lee’s Furniture manufactures two types of chairs---recliner and office chair. The following activity and cost information...
Lee’s Furniture manufactures two types of chairs---recliner and office chair. The following activity and cost information has been compiled:                                Number of             Number of                        Number of Product                         Setups          Components           Direct Labor Hours Recliner                                5                          40                                    300 Office chair                           8                          45                                    175 Overhead costs          $80,000               $180,000 Assume a traditional costing system applies the $260,000 of overhead costs based on direct labor hours. a.   What is the total amount of overhead costs assigned to the recliner? b.   What is the total amount...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT