1. XYZ Sporting Corp. manufactures two types of products – Footwear and Apparel. The following table...

1. XYZ Sporting Corp. manufactures two types of products – Footwear and Apparel. The following table shows the estimated annual overhead cost of XYZ for the year of 2019 -

Production department:
Indirect factory wages	$700,000
Factory equipment depreciation	$250,000
Factory utilities	$130,000
Factory building lease	$80,000	$1,160,000
General Administrative Department:
Administrative wages & salaries	$500,000
Office equipment depreciation	$10,000
Administrative building lease	$60,000	$570,000
Marketing department:
Marketing wages & salaries	$350,000
Selling expenses	$70,000	$420,000
Total overhead cost		$2,150,000

XYZ usually deploys a plantwide overhead rate based on machine hours. But the management of the company decided to implement an activity-based costing (ABC) system to allocate all $2,150,000 of its overhead costs to three cost pools –

Activity cost pool	Activity measures	Footwear	Apparel
Customer orders	Number of customer orders	600 Orders	500 Orders
Product design	Number of product designs	100 Designs	400 Designs
Order size	Machine-hours	15,500 Machine Hours	9,500 Machine Hours

The following table shows the distribution of resource consumption across the activity cost pools

	Customer order	Product design	Order size
Production Department:
Indirect factory wages	20%	40%	40%
Factory equipment depreciation	20%	0%	80%
Factory utilities	0%	10%	90%
Factory building lease	0%	0%	100%
General Administrative Department:
Administrative wages & salaries	15%	5%	80%
Office equipment depreciation	30%	0%	70%
Administrative building lease	0%	0%	100%
Marketing Department:
Marketing wages & salaries	22%	8%	70%
Selling expenses	10%	0%	90%

Calculate the company’s plantwide overhead rate. Using the plantwide overhead rate,how much overhead cost is allocated to Apparel and how much is allocated to Footwear?
Calculate the activity rates of Customer Orders, Product Design, and Order Size. )
Using the ABC system, how much overhead cost is allocated to Apparel and how much is allocated to Footwear?

Expert Solution

ekkarill92 answered 1 year ago

SportChek is Canada’s largest retailer of sporting goods and sports apparel and footwear, with over 130...

SportChek is Canada’s largest retailer of sporting goods and sports apparel and footwear, with over 130 stores across the country. Assume one of the SportChek stores reported current assets of $87,000 and its current ratio was 1.76. Assume that the following transactions were completed: Paid $6,100 on accounts payable. Purchased a delivery truck for $9,500 cash. Wrote off a bad account receivable for $2,100. Paid previously declared dividends in the amount of $24,000. Required: Compute the updated current ratio. (Round...

1. To keep track of vendors and products they supply, XYZ Corp. uses the table structure...

1. To keep track of vendors and products they supply, XYZ Corp. uses the table structure shown below. Assuming that the sample data are representative, draw a dependency diagram in Visio that shows all functional dependencies including both partial and transitive dependencies. (Hint: Look at the sample values to determine the nature of the relationships.) PART_CODE PART_DESC VEND_NAME VEND_ADDRESS VEND_TYPE PRICE 1234 Logic Chip Fast Chips Cupertino Non-profit organization 25.00 1234 Logic Chip Smart Chips Phoenix Non-profit organization 22.00 5678...

XYZ Corp. manufactures a variety of appliances which all use Part Generic. Currently, XYZ Corp manufactures...

XYZ Corp. manufactures a variety of appliances which all use Part Generic. Currently, XYZ Corp manufactures Part Generic at their production facility. Assume XYZ Corp. can purchase 14,000 units of the part from the ALL Parts Company for $20.50 each. It has been producing 14,000 units of Part Generic annually. The per unit costs of producing Part Generic at the level of 14,000 units include: Direct materials $ 3.20 per unit Direct labor $ 8.20 per unit Variable manufacturing overhead ...

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.

The following table, contains annual returns for the stocks of ABC Corp. (ABC ) and XYZ...

The following table, contains annual returns for the stocks of ABC Corp. (ABC ) and XYZ Corp. (XYZ ). The returns are calculated using end-of-year prices (adjusted for dividends and stock splits). Use the information for ABC Corp. (ABC ) and XYZ Corp. (XYZ ) to create an Excel spreadsheet that calculates the average returns over the 10-year period for portfolios comprised of ABC and XYZ using the following, respective, weightings: (1.0, 0.0), (0.9, 0.1). The average annual returns over...

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

2.) A company manufactures two types of products, A and B. The unit revenues are $2...

2.) A company manufactures two types of products, A and B. The unit revenues are $2 and $3, respectively. Two raw materials M1 and M2, used in the manufacture of the two products have daily availabilities of 4 and 6 units, respectively. One unit of A uses 1 unit of M1 and 1 unit of M2, and one unit of B uses 1 unit of M1 and 2 units of M2. a) Formulate a linear programming model and obtain the...

Table 6 Easy Cook Company manufactures two products: toaster ovens and bread machines. The following data...

Table 6 Easy Cook Company manufactures two products: toaster ovens and bread machines. The following data are available: Toaster Ovens Bread Machines Sale price $60 $135 Variable costs 38 62 The company can manufacture five toaster ovens per machine hour and three bread ovens per machine hour. The company’s production capacity is 1,500 machine hours per month. Refer to Table 6. To maximize profits, the company should produce ________.

Suppose that an economy produces only two types of products: machines and clothing. The table below...

Suppose that an economy produces only two types of products: machines and clothing. The table below shows the total production per week, assuming that production in both Product is based on the optimal use of resources. Required: ( Answers should be computerized ) 1 - Draw and Plot the production potential of this economy, then calculate the cost of the opportunity for each distribution, what do you notice about the graph and the cost of the opportunity? 2- Can the...

Pepper’s Products manufactures and sells two types of chew toys for pets, Squeaky and Silent. In...

Pepper’s Products manufactures and sells two types of chew toys for pets, Squeaky and Silent. In May, Pepper’s Products had the following costs and revenues: Pepper's Products Income Statement For the Month of May Squeaky Silent Total Sales revenue $ 149,000 $ 170,000 $ 319,000 Direct materials 19,000 22,000 41,000 Direct labor 80,000 20,000 100,000 Overhead costs Administration 20,000 Production setup 45,000 Quality control 15,000 Distribution 20,000 Operating profit $ 78,000 Pepper’s Products currently uses labor costs to allocate all...

Question