Kuantan ATV, Inc. assembles five different models of all-terrain vehicles (ATVs) from various ready-made components to serve the Las Vegas, Nevada, market. The company uses the same engine for all its ATVs. The purchasing manager, Ms. Jane Kim, needs to choose a supplier for engines for the coming year. Due to the size of the warehouse and other administrative restrictions, she must order the engines in lot sizes of 1,000 each. The unique characteristics of the standardized engine require special tooling to be used during the manufacturing process. Kuantan ATV agrees to reimburse the supplier for the tooling. This is a critical purchase, since late delivery of engines would disrupt production and cause 50 percent lost sales and 50 percent back orders of the ATVs. Jane has obtained quotes from two reliable suppliers but needs to know which supplier is more cost-effective. The terms of sale are 5/10 net 30 for Supplier 1 and 3/10 net 30 for Supplier 2. The data related to the costs of ownership associated with two reliable suppliers has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
Questions
1. What is the total cost of ownership for each of the suppliers? Assume the buyer will take advantage of the largest discount. Do not round intermediate calculations. Round your answers to the nearest cent.
| Supplier 1 | Supplier 2 | |
| Total | $ | $ |
2. Which supplier is more cost-effective?
| Total Cost of Ownership Analysis | ||||||||
| Unit Price | Supplier 1 | Supplier 2 | ||||||
| Requirements (annual forecast units) | 14,000 | 1 to 999 units per order | $530.00 | $520.00 | ||||
| Lot size (Q) | 1,000 | 1000 to 2999 units per order | $520.00 | $515.00 | ||||
| Weight per engine (lbs) | 29 | 3000+ units per order | $510.00 | $506.00 | ||||
| Order processing cost (per order) | $125.00 | Tooling cost | $25,000 | $22,000 | ||||
| Inventory carrying rate (per year) | 24% | Terms (net 30) | 5% | 3% | ||||
| Cost of working capital (per year) | 5% | Distance (miles) | 140 | 100 | ||||
| Profit margin | 20% | Supplier Quality Rating (defects) | 3% | 2% | ||||
| Price of finished ATV | $5,000 | Supplier Delivery Rating (lateness) | 2% | 3% | ||||
| Back-order cost (per unit) | $19.00 | |||||||
| Back-order lost sales | 50% | Supplier 1 | Supplier 2 | Formulas | ||||
| Late delivery lost sales | 50% | Total engine cost | #N/A | #N/A | ||||
| Cash discount (net 30) | #N/A | #N/A | ||||||
| Other Information | Cash discount (early payment) | #N/A | #N/A | |||||
| Truckload (TL>=40,000 lbs) | $0.60 | per ton-mile | Tooling cost | #N/A | #N/A | |||
| Less-than-truckload (LTL) | $1.20 | per ton-mile | Transportation cost | #N/A | #N/A | |||
| Per ton-mile | 2,000 | lbs per mile | Ordering cost | #N/A | #N/A | |||
| Days per year | 365 | Carrying cost | #N/A | #N/A | ||||
| Invoice payment period (days) | 30 | Quality cost | #N/A | #N/A | ||||
| Discount period (days) | 10 | Backorder cost | #N/A | #N/A | ||||
| Lost sales cost | #N/A | #N/A | ||||||
| Total cost | #N/A | #N/A | ||||||
| Lowest cost | #N/A |
In: Math
1.(B)Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to hundreds of hospitals. Worley sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 8%. For example, if a hospital buys supplies from Worley that cost Worley $100 to buy from manufacturers, Worley would charge the hospital $108 to purchase these supplies.
For years, Worley believed that the 8% markup covered its selling and administrative expenses and provided a reasonable profit. However, in the face of declining profits, Worley decided to implement an activity-based costing system to help improve its understanding of customer profitability. The company broke its selling and administrative expenses into five activities as shown:
Activity Cost Pool (Activity Measure)Total CostTotal ActivityCustomer deliveries (Number of deliveries)$567,0007,000deliveriesManual order processing (Number of manual orders) 312,0004,000ordersElectronic order processing (Number of electronic orders) 208,00013,000ordersLine item picking (Number of line items picked) 574,000410,000line itemsOther organization-sustaining costs (None) 690,000 Total selling and administrative expenses$2,351,000
Worley gathered the data below for two of the many hospitals that it serves—University and Memorial (each hospital purchased medical supplies that had cost Worley $32,000 to buy from manufacturers):
Activity
Activity MeasureUniversityMemorialNumber of deliveries1228Number of manual orders043Number of electronic orders170Number of line items picked110250
Required:
1. Compute the total revenue that Worley would receive from University and Memorial.
2. Compute the activity rate for each activity cost pool.
3. Compute the total activity costs that would be assigned to University and Memorial.
4. Compute Worley's customer margin for University and Memorial. (Hint: Do not overlook the $32,000 cost of goods sold that Worley incurred serving each hospital.)
In: Accounting
Stillicum Corporation makes ultra light-weight backpacking
tents. Data concerning the company’s two product lines appear
below:
| Deluxe | Standard | |||||
| Direct materials per unit | $ | 64.00 | $ | 52.00 | ||
| Direct labor per unit | $ | 22.00 | $ | 18.00 | ||
| Direct labor-hours per unit | 0.70 | DLHs | 1.40 | DLHs | ||
| Estimated annual production | 10,000 | units | 50,000 | units | ||
The company has a traditional costing system in which
manufacturing overhead is applied to units based on direct
labor-hours. Data concerning manufacturing overhead and direct
labor-hours for the upcoming year appear below:
| Estimated total manufacturing overhead | $ | 570,000 | |
| Estimated total direct labor-hours | 77,000 | DLHs | |
Required:
1. Determine the unit product costs of the Deluxe and Standard products under the company’s traditional costing system.
2. The company is considering replacing its traditional costing
system with an activity-based absorption costing system that would
have the following three activity cost pools:
| Expected Activity | |||||
| Activity Cost Pools and Activity Measures | Estimated Overhead Cost |
Deluxe | Standard | Total | |
| Supporting direct labor (direct labor-hours) | $ | 385,000 | 7,000 | 70,000 | 77,000 |
| Batch setups (setups) | 120,000 | 200 | 100 | 300 | |
| Safety testing (tests) | 65,000 | 30 | 70 | 100 | |
| Total manufacturing overhead cost | $ | 570,000 | |||
Determine the unit product costs of the Deluxe and Standard products under the company’s traditional costing system. (Round your intermediate calculations and final answers to 2 decimal places.)
|
Determine the unit product costs of the Deluxe and Standard products under the activity-based absorption costing system. (Round your intermediate calculations and final answers to 2 decimal places.)
|
In: Accounting
Prior to the first month of operations ending October 31 Marshall Inc. estimated the following operating results:
| Sales (20,000 x $71) | $1,420,000 | ||
| Manufacturing costs (20,000 units): | |||
| Direct materials | 852,000 | ||
| Direct labor | 202,000 | ||
| Variable factory overhead | 94,000 | ||
| Fixed factory overhead | 112,000 | ||
| Fixed selling and administrative expenses | 30,500 | ||
| Variable selling and administrative expenses | 36,800 | ||
The company is evaluating a proposal to manufacture 22,400 units instead of 20,000 units, thus creating an Inventory, October 31 of 2,400 units. Manufacturing the additional units will not change sales, unit variable factory overhead costs, total fixed factory overhead cost, or total selling and administrative expenses.
a. 1. Prepare an estimated income statement, comparing operating results if 20,000 and 22,400 units are manufactured in the absorption costing format. If an amount box does not require an entry leave it blank or enter “0”.
| Marshall Inc. | ||
| Absorption Costing Income Statement | ||
| For the Month Ending October 31 | ||
| 20,000 Units Manufactured | 22,400 Units Manufactured | |
| Sales | $ | $ |
| Cost of goods sold: | ||
| Cost of goods manufactured | $ | $ |
| Inventory, October 31 | ||
| Total cost of goods sold | $ | $ |
| Gross profit | $ | $ |
| Selling and administrative expenses | ||
| Income from operations | $ | $ |
Feedback
a. 2. Prepare an estimated income statement, comparing operating results if 20,000 and 22,400 units are manufactured in the variable costing format. If an amount box does not require an entry leave it blank or enter “0”.
| Marshall Inc. | ||
| Variable Costing Income Statement | ||
| For the Month Ending October 31 | ||
| 20,000 Units Manufactured | 22,400 Units Manufactured | |
| Sales | $ | $ |
| Variable cost of goods sold: | ||
| Variable cost of goods manufactured | $ | $ |
| Inventory, October 31 | ||
| $ | $ | |
| $ | $ | |
| $ | $ | |
| Fixed costs: | ||
| $ | $ | |
| Total fixed costs | $ | $ |
| $ | $ | |
In: Accounting
Model Z $93
Model EF $88
Model DS $127
Sonata Corporation has 5 activities—assembly, materials management, testing, inspecting and milling. The cost driver for assembly is machine hours. Total costs and production volumes for the year 2019 were estimated as follows
|
Total Indirect cost |
Allocation Base |
Cost Driver |
|
|
Assembly |
$992,500 |
240,600 |
Machine hours |
|
Materials management |
$405,600 |
42,500 |
Parts |
|
Testing |
$190,000 |
7,000 |
Units |
|
Inspection |
$120,400 |
4,775 |
Inspections |
|
Milling |
$215,750 |
220,050 |
Milling Minutes |
The following is the amount each product uses of each driver:
|
Model Z |
Model EF |
Model DS |
|
|
No. Of Units |
1,005 |
730 |
885 |
|
Assembly |
61,305 Machine Hours |
45,260 Machine hours |
56,640 Machine Hours |
|
Materials management |
5,025 parts |
2,190 parts |
6,195 parts |
|
Testing |
402 units |
365 units |
354 units |
|
Inspection |
201 inspections |
292 inspections |
177 inspections |
|
Milling |
31,155 Milling Minutes |
25,550 Milling Minutes |
25,665 Milling Minutes |
In: Accounting
Income Statements under Absorption Costing and Variable Costing
Fresno Industries Inc. manufactures and sells high-quality camping tents. The company began operations on January 1 and operated at 100% of capacity (46,200 units) during the first month, creating an ending inventory of 4,200 units. During February, the company produced 42,000 units during the month but sold 46,200 units at $100 per unit. The February manufacturing costs and selling and administrative expenses were as follows:
| Number of Units | Unit Cost | Total Cost |
||||
| Manufacturing costs in February 1 beginning inventory: | ||||||
| Variable | 4,200 | $40.00 | $168,000 | |||
| Fixed | 4,200 | 15.00 | 63,000 | |||
| Total | $55.00 | $231,000 | ||||
| Manufacturing costs in February: | ||||||
| Variable | 42,000 | $40.00 | $1,680,000 | |||
| Fixed | 42,000 | 16.50 | 693,000 | |||
| Total | $56.50 | $2,373,000 | ||||
| Selling and administrative expenses in February: | ||||||
| Variable | 46,200 | $19.50 | $900,900 | |||
| Fixed | 46,200 | 7.00 | 323,400 | |||
| Total | $26.50 | $1,224,300 | ||||
a. Prepare an income statement according to the absorption costing concept for the month ending February 28.
| Fresno Industries Inc. | ||
| Absorption Costing Income Statement | ||
| For the Month Ended February 28 | ||
| $ | ||
| Cost of goods sold: | ||
| $ | ||
| $ | ||
| $ | ||
b. Prepare an income statement according to the variable costing concept for the month ending February 28.
| Fresno Industries Inc. | ||
| Variable Costing Income Statement | ||
| For the Month Ended February 28 | ||
| $ | ||
| $ | ||
| $ | ||
| Fixed costs: | ||
| $ | ||
| $ | ||
c. What is the reason for the difference in the amount of operating income reported in (a) and (b)?
Under the method, the fixed manufacturing cost included in the cost of goods sold is matched with the revenues. Under , all of the fixed manufacturing cost is deducted in the period in which it is incurred, regardless of the amount of inventory change. Thus, when inventory decreases, the income statement will have a lower operating income.
In: Accounting
40. TaskMaster Enterprises employs a standard cost system in which direct materials inventory is carried at standard cost. TaskMaster has established the following standards for the prime costs of one unit of product.
| Standard | Standard | Standard | ||||||||||
| Quantity | Price | Cost | ||||||||||
| Direct Materials | 8 | pounds | $ | 1.80 | per pound | $ | 14.40 | |||||
| Direct Labor | .20 | hour | $ | 9.00 | per hour | 1.80 | ||||||
| $ | 16.20 | |||||||||||
During November, TaskMaster purchased 200,000 pounds of direct materials at a total cost of $400,000. The total factory wages for November were $44,000, 90% of which were for direct labor. TaskMaster manufactured 23,000 units of product during November using 182,000 pounds of direct materials and 5,000 direct labor hours.
What is the direct materials efficiency (quantity) variance for November?
$28,800.
$3,600.
$36,400.
$40,000.
41. In 2016, Evans Corporation had an operating profit of $764,000 and a residual income of $307,000. If Evans' cost of capital is 10%, what is the amount of the invested capital?
$3,070,000.
$2,613,000.
$7,640,000.
$4,570,000.
42.
| Denominator hours for May | 22,500 | ||
| Actual hours worked during May | 21,500 | ||
| Standard hours allowed for May | 19,500 | ||
| Flexible budget fixed overhead cost | $ | 67,500 | |
| Actual fixed overhead costs for May | $ | 72,000 | |
Danske Company had total underapplied overhead of $22,500. Additional information is as follows:
| Variable Overhead: | |||
| Applied based on standard direct labor hours allowed | $ | 57,000 | |
| Budgeted based on standard direct labor hours | 45,500 | ||
| Fixed Overhead: | |||
| Applied based on standard direct labor hours allowed | $ | 45,000 | |
| Budgeted based on standard direct labor hours | 34,500 | ||
What is the actual total overhead for the period?
$57,500.
$102,500.
$124,500.
$67,500.
In: Accounting
Income Statements under Absorption Costing and Variable Costing
Fresno Industries Inc. manufactures and sells high-quality camping tents. The company began operations on January 1 and operated at 100% of capacity (77,000 units) during the first month, creating an ending inventory of 7,000 units. During February, the company produced 70,000 units during the month but sold 77,000 units at $90 per unit. The February manufacturing costs and selling and administrative expenses were as follows:
| Number of Units | Unit Cost | Total Cost |
||||
| Manufacturing costs in February 1 beginning inventory: | ||||||
| Variable | 7,000 | $36.00 | $252,000 | |||
| Fixed | 7,000 | 14.00 | 98,000 | |||
| Total | $50.00 | $350,000 | ||||
| Manufacturing costs in February: | ||||||
| Variable | 70,000 | $36.00 | $2,520,000 | |||
| Fixed | 70,000 | 15.40 | 1,078,000 | |||
| Total | $51.40 | $3,598,000 | ||||
| Selling and administrative expenses in February: | ||||||
| Variable | 77,000 | $18.20 | $1,401,400 | |||
| Fixed | 77,000 | 7.00 | 539,000 | |||
| Total | $25.20 | $1,940,400 | ||||
a. Prepare an income statement according to the absorption costing concept for the month ending February 28.
| Fresno Industries Inc. | ||
| Absorption Costing Income Statement | ||
| For the Month Ended February 28 | ||
| $ | ||
| Cost of goods sold: | ||
| $ | ||
| $ | ||
| $ | ||
b. Prepare an income statement according to the variable costing concept for the month ending February 28.
| Fresno Industries Inc. | ||
| Variable Costing Income Statement | ||
| For the Month Ended February 28 | ||
| $ | ||
| $ | ||
| $ | ||
| Fixed costs: | ||
| $ | ||
| $ | ||
c. What is the reason for the difference in the amount of operating income reported in (a) and (b)?
Under the method, the fixed manufacturing cost included in the cost of goods sold is matched with the revenues. Under , all of the fixed manufacturing cost is deducted in the period in which it is incurred, regardless of the amount of inventory change. Thus, when inventory decreases, the income statement will have a lower operating income.
In: Accounting
home / study / business / accounting / accounting questions and answers / homework for intra-entity transactions. part i paula corporation owns all of the voting common ...
Question: Homework for intra-entity transactions. Part I Paula Corporation owns all of the voting common st...
Homework for intra-entity transactions.
Part I
Paula Corporation owns all of the voting common stock of Sally Company. Sally manufactures toys and sells them to Paula. In turn, Paula sells them to customers. Neither of these companies do anything else. At the beginning of 2012 neither company had any inventory. During 2012 Sally manufactured 120,000 toys and sold 100,000 of them to Paula for $10 each and Paula sold 90,000 of these toys to customers for $16 each. These toys had cost Sally only $7 each to produce. During 2013 Sally manufactured 115,000 toys and sold 98,000 to Paula for $10 each. Paula sold 100,000 toys to customers during 2013 for $16 each. (The manufacturing cost for Sally was still $7 per toy.) Please determine each of the following:
A. Total Consolidated Sales Revenue for 2013
B. Total Consolidated Cost of Goods Sold for 2013
C. Consolidated Ending Inventory for December 31, 2013
During 2014 Sally produced 200,000 toys at a cost of $7 each. Paula produced 30,000 books at a cost of $12 each. Sally sold 120,000 toys to Paula for $10 each and 50,000 toys to customers for $15 each. Paula sold 110,000 of the toys to customers for $16 each and 20,000 books to customers for $20 each. Please determine each of the following:
A. Total Consolidated Sales Revenue for 2014
B. Total Consolidated Cost of Goods Sold for 2014
C. Consolidated Ending Inventory for December 31, 2014
In: Accounting
Income Statements under Absorption Costing and Variable Costing
Joplin Industries Inc. manufactures and sells high-quality sporting goods equipment under its highly recognizable J-Sports logo. The company began operations on May 1 and operated at 100% of capacity (66,000 units) during the first month, creating an ending inventory of 6,000 units. During June, the company produced 60,000 garments during the month but sold 66,000 units at $95 per unit. The June manufacturing costs and selling and administrative expenses were as follows:
| Number of Units | Unit Cost | Total Cost |
||||
| Manufacturing costs in June 1 beginning inventory: | ||||||
| Variable | 6,000 | $38.00 | $228,000 | |||
| Fixed | 6,000 | 14.00 | 84,000 | |||
| Total | $52.00 | $312,000 | ||||
| Manufacturing costs in June: | ||||||
| Variable | 60,000 | $38.00 | $2,280,000 | |||
| Fixed | 60,000 | 15.40 | 924,000 | |||
| Total | $53.40 | $3,204,000 | ||||
| Selling and administrative expenses in June: | ||||||
| Variable | 66,000 | 18.20 | $1,201,200 | |||
| Fixed | 66,000 | 7.00 | 462,000 | |||
| Total | 25.20 | $1,663,200 | ||||
a. Prepare an income statement according to the absorption costing concept for June.
| Joplin Industries Inc. | ||
| Absorption Costing Income Statement | ||
| For the Month Ended June 30 | ||
| $ | ||
| Cost of goods sold: | ||
| $ | ||
| $ | ||
| $ | ||
b. Prepare an income statement according to the variable costing concept for June.
| Joplin Industries Inc. | ||
| Variable Costing Income Statement | ||
| For the Month Ended June 30 | ||
| $ | ||
| $ | ||
| $ | ||
| Fixed costs: | ||
| $ | ||
| $ | ||
c. What is the reason for the difference in the amount of income from operations reported in (a) and (b)?
Under the method, the fixed manufacturing cost included in the cost of goods sold is matched with the revenues. Under , all of the fixed manufacturing cost is deducted in the period in which it is incurred, regardless of the amount of inventory change. Thus, when inventory decreases, the income statement will have a lower income from operations.
In: Accounting