Show your work for calculated problems. Type answers, for example, #EA4, directly into a worksheet within a workbook in Excel – label the worksheet the same as the problem.

EA  1. 

LO 2.1 Magio Company manufactures kitchen equipment used in hospitals. They distribute their products directly to the customer and, for the year ending 2019, they reported the following revenues and expenses. Use this information to construct an income statement for the year 2019.

EA  2. 

LO 2.1 Park and West, LLC, provides consulting services to retail merchandisers in the Midwest. In 2019, they generated $720,000 in service revenue. Their total cost (fixed and variable) per client was $2,500 and they served 115 clients during the year. If operating expenses for the year were $302,000 what was their net income?

EA  3. 

LO 2.1 Canine Couture is a specialty dog clothing boutique that sells clothing and clothing accessories for dogs. In 2019, they had gross revenue from sales totaling $86,500. Their operating expenses for this same period were $27,500. If their Cost of Goods Sold (COGS) was 24% of gross revenue, what was their net operating income for the year?

EA  4. 

LO 2.2 Hicks Contracting collects and analyzes cost data in order to track the cost of installing decks on new home construction jobs. The following are some of the costs that they incur. Classify these costs as fixed or variable costs and as product or period costs.

A. Lumber used to construct decks ($12.00 per square foot)

B. Carpenter labor used to construct decks ($10 per hour)

C. Construction supervisor salary ($45,000 per year)

D. Depreciation on tools and equipment ($6,000 per year)

E. Selling and administrative expenses ($35,000 per year)

F. Rent on corporate office space ($34,000 per year)

G. Nails, glue, and other materials required to construct deck (varies per job)

EA  5. 

LO 2.2 Rose Company has a relevant range of production between 10,000 and 25,000 units. The following cost data represents average cost per unit for 15,000 units of production.

Using the cost data from Rose Company, answer the following questions:

A. If 10,000 units are produced, what is the variable cost per unit?

B. If 18,000 units are produced, what is the variable cost per unit?

C. If 21,000 units are produced, what are the total variable costs?

D. If 11,000 units are produced, what are the total variable costs?

E. If 19,000 units are produced, what are the total manufacturing overhead costs incurred?

F. If 23,000 units are produced, what are the total manufacturing overhead costs incurred?

G. If 19,000 units are produced, what are the per unit manufacturing overhead costs incurred?

H. If 25,000 units are produced, what are the per unit manufacturing overhead costs incurred?

EA  6. 

LO 2.2 Carr Company provides human resource consulting services to small- and medium-sized companies. Last year, Carr provided services to 700 clients. Total fixed costs were $159,000 with total variable costs of $87,500. Based on this information, complete this chart:

EA  7. 

LO 2.2 Western Trucking operates a fleet of delivery trucks. The fixed expenses to operate the fleet are $79,900 in March and rose to $93,120 in April. It costs Western Trucking $0.15 per mile in variable costs. In March, the delivery trucks were driven a total of 85,000 miles, and in April, they were driven a total of 96,000 miles. Using this information, answer the following:

A. What were the total costs to operate the fleet in March and April, respectively?

B. What were the cost per mile to operate the fleet in March and April, respectively?

EA  8. 

LO 2.2 Suppose that a company has fixed costs of $18 per unit and variable costs $9 per unit when 15,000 units are produced. What are the fixed costs per unit when 12,000 units are produced?

EA  9. 

LO 2.3 The cost data for Evencoat Paint for the year 2019 is as follows:

A. Using the high-low method, express the company’s maintenance costs as an equation where  x represents the gallons of paint produced. Then estimate the fixed and variable costs.

B. Predict the maintenance costs if 90,000 gallons of paint are produced.

C. Predict the maintenance costs if 81,000 gallons of paint are produced.

D. Using Excel, create a scatter graph of the cost data and explain the relationship between gallons of paint produced and equipment maintenance expenses.