BUQU 1230 - Assignment 2 PDF

Preview

Summary

It is about the proper use of MS-Excel and how to do use mean, mode, median functions....

Description

Fall 2021 BUQU 1130-A90 Assignment # 2 Due: Saturday, October 2nd, 2021, at 11:59pm (Vancouver-time) Assignments can be completed either individually or in groups. If you choose to work in groups, there can only be a maximum 4 students per group. You are free to work in different groups throughout the semester.

Chapter 5, questions #6 & 9 (pages 165-166) in textbook. Question 6. In the North American automotive markets, Toyota and Honda are two of the big players. The following financial information (all numbers in millions of dollars) for each was reported to its shareholders: Total Revenue Total Variable Costs Total Fixed Costs Total Costs Net Income

Toyota $247,734 $204,135 $20,938 $225,073 $22,661

Honda $101,916 $75,532 $24,453 $99,985 $1,931

Compare the break-even points in total dollars between the two companies based on these reports.

Question 9. A surfboard manufacturer lost $500,000 last year during a recession. Total revenue was $5,000,000 and total variable costs were 40% of sales. The production facility ran at 50% capacity. The production manager wants to know the following: a) What is the percent capacity required to break even? b) When the economy recovers this year, if the plant runs at 100% capacity what net income could the company realize? c) There is a possibility that sales could be so strong this year that the plant may be required to run at 120% capacity by offering a lot of overtime to its production workers. This would result in total variable costs rising by 35%. On a strictly financial basis, should the production manager plan to exceed capacity or should he advise top management to freeze production at 100% capacity? Justify your answer.

Chapter 6, questions #10 & 17 (pages 222-223) in textbook. Question 10. The marketing manager for Tim Hortons is attempting to price a cup of coffee. She knows that the cost of the coffee is $0.14 per cup, and expenses are 30% of the regular selling price. She would like the coffee to achieve an 88.24% markup on selling price. a) What is the regular selling price for a cup of coffee?

b) What is the profit per cup? c) What is the markup on cost percentage? Question 17. Whistler Blackcomb Ski Resort purchased 400 pairs of skis for sale in its retail store. It sells the skis at an MSRP of $299.99. It is eligible to receive discounts of 35% and 20% on its purchase. Expenses average 15% of cost. If it sells 300 pairs of skis at the regular unit selling price and the other 100 skis are sold during a clearance sale for 20% off, what is the total amount of profit that Whistler Blackcomb earns? What is the maintained markup?...