Cost Identification and Analysis, Cost Assignment, Income Statement
Melissa Vassar has decided to open a printing shop. She has secured two contracts. One is a 5-year contract to print a popular regional magazine. This contract calls for 5,000 copies each month. The second contract is a 3-year agreement to print tourist brochures for the state. The state tourist office requires 10,000 brochures per month.
Melissa has rented a building for $1,400 per month. Her printing equipment was purchased for $40,000 and has a life expectancy of 20,000 hours with no salvage value.
Insurance costs for the building and equipment are $140 per month. Power to operate the printing equipment is strongly related to machine usage. The printing equipment causes virtually all the power costs. Power costs will run $350 per month. Printing materials will cost $0.40 per copy for the magazine and $0.08 per copy for the brochure. Melissa will hire workers to run the presses as needed (part-time workers are easy to hire). She must pay $10 per hour. Each worker can produce 20 copies of the magazine per printing hour or 100 copies of the brochure. Distribution costs are $500 per month. Melissa will receive a salary of $1,500 per month. She is responsible for personnel, accounting, sales, and production—in effect, she is responsible for administering all aspects of the business.
Required:
- 1. What are the total monthly
manufacturing costs ? - 2. What are the total monthly prime costs? What are the total monthly prime costs for the regional magazine? For the brochure?
- 3. What are the total monthly conversion costs? Suppose Melissa wants to determine monthly conversion costs for each product. Assign monthly conversion costs to each product using direct tracing and driver tracing whenever possible. For those costs that cannot be assigned using a tracing approach, you may assign them using direct labor hours.
- 4. Melissa receives $1.80 per copy of the magazine and $0.45 per brochure. Prepare an income statement for the first month of operations.
1.
Calculate the amount of total monthly manufacturing costs.
Answer to Problem 60P
The total monthly manufacturing cost is $9,490.
Explanation of Solution
Manufacturing Costs:
Manufacturing costs can be defined as the total amount of costs incurred in producing a product. Manufacturing costs involve the cost of direct materials, cost of direct labor and manufacturing overheads.
The below table represents the total manufacturing cost:
Amount ($) | Amount ($) | |
Direct materials: | ||
Magazine | 2,000 | |
Brochure | 800 | 2,800 |
Direct labor: | ||
Magazine | 2,500 | |
Brochure | 1,000 | 3,500 |
Manufacturing overhead: | ||
Rent | 1,400 | |
Depreciation | 700 | |
Setups | 600 | |
Insurance | 140 | |
Power | 350 | 3,190 |
Cost of goods manufactured | 9,490 |
Table (1)
The total monthly manufacturing cost is $9,490.
Working Notes:
1.
Calculation of direct material-magazine:
Hence, the amount of direct material-magazine is $2,000.
2.
Calculation of direct material-brochure:
Hence, the amount of direct material-brochure is $800.
3.
Calculation of direct labor-magazine:
Hence, the amount of direct labor-magazine is $2,500.
4.
Calculation of direct labor-brochure:
Hence, the amount of direct labor- brochure is $1,000.
5.
Calculation of monthly machine hours:
Hence, the monthly machine hours are 350 hours.
6.
Calculation of depreciation:
Therefore, the amount of depreciation is $700.
2.
Calculate the amount of monthly prime costs, magazine’s and brochure’s monthly prime costs.
Answer to Problem 60P
The amount of monthly prime costs, magazine’s monthly prime costs, and brochure’s monthly prime costs are $6,300, $4,500 and $1,800 respectively.
Explanation of Solution
Use the following formula to compute the monthly total prime cost:
Substitute $2,800 for direct material and $3,500 for direct labor in the above formula.
Therefore, the amount of total monthly prime cost is $6,300.
Use the following formula to compute the monthly prime cost of the magazine:
Substitute $2,000 for direct material of magazine and $2,500 for direct labor of magazine in the above formula.
Therefore, the amount of total monthly prime cost of the magazine is $4,500.
Use the following formula to compute the monthly prime cost of the brochure:
Substitute $800 for direct material of brochure and $1,000 for direct labor of brochure in the above formula.
Therefore, the amount of total monthly prime cost of the brochure is $1,800.
3.
Calculate the amount of total monthly conversion cost. Also, assign the conversion costs to each product with the help of direct tracing and driver tracing.
Answer to Problem 60P
The amount of total monthly conversion cost is $6,690. And the total conversion costs of the magazine and brochure are $4,750 and $1,940 respectively.
Explanation of Solution
Use the following formula to compute the conversion cost:
Substitute $3,500 for direct labor and $3,190 for direct labor in the above formula.
Therefore, the amount of conversion cost is $6,690.
Following is the allocation of conversion costs to the product magazine:
Amount ($) | Amount ($) | |
Direct labor | 2,500 | |
Manufacturing overheads: | ||
Power | 250 | |
Depreciation | 500 | |
Setups | 400 | |
Rent and insurance | 1,100 | 2,250 |
Total | 4,750 |
Table (2)
Therefore, the total conversion cost of the magazine is $4,750.
Following is the allocation of conversion costs to the product brochure:
Amount ($) | Amount ($) | |
Direct labor | 1,000 | |
Manufacturing overheads: | ||
Power | 100 | |
Depreciation | 200 | |
Setups | 200 | |
Rent and insurance | 440 | 940 |
Total | 1,940 |
Table (3)
Therefore, the total conversion cost of the brochure is $1,940.
Working Notes:
1.
Calculation of monthly machine hours:
Hence, the monthly machine hours are 350 hours.
2.
Calculation of the amount of power for the magazine:
Hence, the amount of power for the magazine is $250.
3.
Calculation of depreciation for magazine:
Hence, the amount of depreciation is $500.
4.
Calculation of setup time for magazine and brochure:
The magazine takes twice as long to configure the brochure. Let the setup time for brochure be a. Therefore, the equation is given below:
Hence, the setup time for the magazine is 1/3 and the setup time for the brochure is 2/3
5.
Calculation of setup amount for the magazine:
Hence, the amount of setup for the magazine is $400.
6.
Calculation of the amount of rent and insurance for the magazine:
Hence, the amount of rent and insurance for the magazine is $1,100.
7.
Calculation of the amount of power for the brochure:
Hence, the amount of power for the brochure is $100.
8.
Calculation of depreciation for brochure:
Hence, the amount of depreciation is $200.
9.
Calculation of setup amount for brochure:
Hence, the amount of setup for the brochure is $200.
10.
Calculation of the amount of rent and insurance for brochure:
Hence, the amount of rent and insurance for the brochure is $440.
4.
Prepare an income statement for the first month of operations.
Explanation of Solution
Income Statement:
The statement that shows revenue and expenses incurred over a period of time (usually one year) is called income statement. It is used for external financial reporting as it helps the outsiders and investors in evaluating the firm’s financial health.
Following is the income statement of M:
Company M | ||
Income Statement | ||
For First Month | ||
Amount ($) | Amount ($) | |
Sales revenue | 13,500 | |
Cost of goods sold | 9,490 | |
Gross margin | 4,010 | |
Less: Operating expense | ||
Selling expense | 500 | |
Administrative expense | 1,500 | 2,000 |
Net Income | 2,010 |
Table (4)
Therefore, the amount of net income is $2,010.
Since the beginning and ending finished goods inventories are zero, the amount of cost of goods manufactured is equal to the cost of goods sold. Also, distribution cost is considered as selling expense, and a salary of $1,500 is considered as an administrative expense.
Working Notes:
Calculation of sales revenue:
Hence, the amount of sales revenue is $13,500.
Want to see more full solutions like this?
Chapter 2 Solutions
Managerial Accounting: The Cornerstone of Business Decision-Making
- At Little Green Apple Produce the owner is considering buying a new large walk in cooler for fruits and vegetables. The new cooler cost $150,000. The annual maintenance cost will be $7,000 starting in year two (the first year will be covered under warrantee). An additional employee will be needed to stock the cooler. The employee will make $16/hr, and start part-time at 20 hours per week. Sale of produce will increase by $100,000 in year one and an additional 10% in year two and 15% in year three. The cost of produce will increase $30,000 in year one and is variable with sales. The part-time employees hours will vary based on additional sales in years two and three. The employee will receive raises of 4% annually and electricity will increase 3% a year. There is no inflation on any other item. Based on this information prepare a pro forma and calculate the project NPV using a 9% discount rate/hurdle rate and calculate the IRR. State if the project should be expected or rejected.…arrow_forwardABC operates a consignment shop where she sells clothes for women and children. The average number of consignments sold per month is 1,000. The average material cost and the selling price of each consignment are $8 and $20, respectively. The monthly fixed costs to run this business are given below: Rental cost: $750Utilities: $150Advertising: $35Insurance: $100Labor cost: $4,000 Using Excel spreadsheet / worksheet, determine Anna's profit. Attach excel solution.arrow_forwardMunoz Camps, Inc. leases the land on which it builds camp sites. Munoz is considering opening a new site on land that requires $2,200 of rental payment per month. The variable cost of providing service is expected to be $5 per camper. The following chart shows the number of campers Munoz expects for the first year of operation of the new site: Jan. Feb. Mar. Apr. May June July Aug. Sept. Oct. Nov. Dec. Total 170 270 230 220 360 520 670 670 370 400 200 320 4,400 Required Assuming that Munoz wants to earn $8 per camper, determine the price it should charge for a camp site in February and August. (Do not round intermediate calculations.)arrow_forward
- Classical Glasses operates a kiosk at the local mall, selling s unglasses for $30 each. Classical Glasses currently pays $1,000 a month to rent the space and pays two full-time employees to each work 160 hours a month at $10 per hour. The store shares a manager with a neighboring kiosk and pays 50% of the manager’s annual salary of $60,000 and benefits of $12,000. The wholesale cost of the sunglasses to the company is $10 a pair. Q1. How many sunglasses does Classical Glasses need to sell each month to break even?arrow_forwardClassical Glasses operates a kiosk at the local mall, selling s unglasses for $30 each. Classical Glasses currently pays $1,000 a month to rent the space and pays two full-time employees to each work 160 hours a month at $10 per hour. The store shares a manager with a neighboring kiosk and pays 50% of the manager’s annual salary of $60,000 and benefits of $12,000. The wholesale cost of the sunglasses to the company is $10 a pair. Q.If the store’s hourly employees agreed to a 15% sales-commission-only pay structure, instead of their hourly pay, how many sunglasses would Classical Glasses need to sell to earn an operating income of $5,300?arrow_forwardClassical Glasses operates a kiosk at the local mall, selling s unglasses for $30 each. Classical Glasses currently pays $1,000 a month to rent the space and pays two full-time employees to each work 160 hours a month at $10 per hour. The store shares a manager with a neighboring kiosk and pays 50% of the manager’s annual salary of $60,000 and benefits of $12,000. The wholesale cost of the sunglasses to the company is $10 a pair. Q.Assume Classical Glasses pays its employees hourly under the original pay structure, but is able to pay the mall 10% of its monthly revenue instead of monthly rent. At what sales levels would Classical Glasses prefer to pay a fixed amount of monthly rent, and at what sales levels would it prefer to pay 10% of its monthly revenue as rent?arrow_forward
- Classical Glasses operates a kiosk at the local mall, selling s unglasses for $30 each. Classical Glasses currently pays $1,000 a month to rent the space and pays two full-time employees to each work 160 hours a month at $10 per hour. The store shares a manager with a neighboring kiosk and pays 50% of the manager’s annual salary of $60,000 and benefits of $12,000. The wholesale cost of the sunglasses to the company is $10 a pair. Q.If Classical Glasses wants to earn an operating income of $5,300 per month, how many sunglasses does the store need to sell?arrow_forwardCurt Rugs is holding a 2-week carpet sale at Jean's Club, a local warehouse store. Curt Rugs plans to sell carpets for $1,000 each. The company will purchase the carpets from a local distributor for $400 each, with the privilege of returning any unsold units for a full refund. Jean's Club has offered Curt Rugs two payment alternatives for the use of space. Read the requirements. Requirement 1. Calculate the breakeven point in units for (a) option 1 and (b) option 2. Begin by determining the formula to calculate the breakeven point in units. Number of units to breakeven More Info • Option 1: A fixed payment of $17,400 for the sale period • Option 2: 20% of total revenues earned during the sale period Assume Curt Rugs will incur no other costs.arrow_forwardHannah Ortega is considering expanding her business. She plans to hire a salesperson to cover trade shows. Because of compensation, travel expenses, and booth rental, fixed costs for a trade show are expected to be $10,780. The booth will be open 22 hours during the trade show. Ms. Ortega also plans to add a new product line, ProOffice, which will cost $180 per package. She will continue to sell the existing product, EZRecords, which costs $94 per package. Ms. Ortega believes that the salesperson will spend approximately 12 hours selling EZRecords and 10 hours marketing ProOffice. Required a. Determine the estimated total cost and cost per unit of each product, assuming that the salesperson is able to sell 78 units of EZRecords and 59 units of ProOffice. b. Determine the estimated total cost and cost per unit of each product, assuming that the salesperson is able to sell 205 units of EZRecords and 110 units of ProOffice. Note: For all requirements, round "Cost per unit" to 2 decimal…arrow_forward
- Hannah Ortega is considering expanding her business. She plans to hire a salesperson to cover trade shows. Because of compensation, travel expenses, and booth rental, fixed costs for a trade show are expected to be $12,690. The booth will be open 27 hours during the trade show. Ms. Ortega also plans to add a new product line, ProOffice, which will cost $180 per package. She will continue to sell the existing product, EZRecords, which costs $103 per package. Ms. Ortega believes that the salesperson will spend approximately 17 hours selling EZRecords and 10 hours marketing ProOffice. Required a. Determine the estimated total cost and cost per unit of each product, assuming that the salesperson is able to sell 72 units of EZRecords and 45 units of ProOffice. b. Determine the estimated total cost and cost per unit of each product, assuming that the salesperson is able to sell 202 units of EZRecords and 101 units of ProOffice. Note: For all requirements, round "Cost per unit" to 2 decimal…arrow_forwardesc You plan on starting a lawn mowing business by investing $700 of your own money and purchasing $500 of equipment. You plan to work 80 hours in your first month and 370 hours in your second month of business. You charge your customers $24 per hour. Your anticipated costs include: Advertising Gas Depreciation Assistant's Wages Miscellaneous Expenses You plan on collecting 90% of your sales in the month you mow the lawn and the remainder in the following month. Calculate the accounts receivable balance at the end of your second month of business. Click Save and Submit to save and submit. Click Save All Answers to save all answers. 1 Q A 2 W $8 per month $1.40 per hour $25 per month $8.00 per hour $40 per month S # 3 E D $ 4 R 67 dº % 5 LL MacBook Pro T < 6 G & Y 7 H * 00 8 U J oarrow_forwardRundle Camps, Inc. leases the land on which it builds camp sites. Rundle is considering opening a new site on land that requires $3,200 of rental payment per month. The variable cost of providing service is expected to be $7 per camper. The following chart shows the number of campers Rundle expects for the first year of operation of the new site: Jan. Feb. 210 290 Mar. Apr. May June July Aug. 270 240 420 540 690 690 Answer is complete but not entirely correct. February August Sept. Oct. 390 420 Required Assuming that Rundle wants to earn $8 per camper, determine the price it should charge for a camp site in February and August. (Do not round Intermediate calculations.) Price S 27 Ⓡ S 20 X Nov. 300 Dec. Total 340 4,800arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College