Question
QUESTION-1 (CONTINUED) Eric: Linda, my wife would be ecstatic if I were able to improve our financial position as Quickly as this opportunity affords. I
QUESTION-1 (CONTINUED)
Eric: "Linda, my wife would be ecstatic if I were able to improve our financial position as
Quickly as this opportunity affords. I certainly hope that you win the bid. What kind of help can I provide?"
Linda: "Simple. To win, all I have to do is beat the bid of your firm. Before 1 submit my bid, I would like you to review it. With the financial skills you have, it should be easy for you to spot any excessive costs that I may have included. Or perhaps I included the wrong kind of costs. By cutting excessive costs and eliminating costs that may not be directly related to the project, my bid should be competitive enough to meet or beat your firm's bid."
Required: (Please note this answer should not be more than 3 pages maximum)
a) What would you do if you were Eric? Explain the reasons for your decision and apply the code of ethics to the proposal given, to Eric assume that Eric is a member of a professional accounting body. (10 marks)
b) What is the risk to Eric personally if he reviews the bid? Should the degree of risk influence his decision? Explain your reasons. (9 marks)
QUESTION 2 PACIFIC AIR CORPORATION (18 marks)
Pacific Air Corporation is a business 'providing a wide variety of aviation products to pilots throughout the world. Dana Lombardi, the recently hired assistant controller, has been asked to develop a cost function to forecast shipping costs. The previous assistant controller had forecasted shipping department costs each year by plotting cost data against; direct labor-hours for the most recent 12 months and visually fitting a straight line through the points. The results were not satisfactory.
After discussions with the shipping department personnel, Lombardi decided that shipping costs could be more closely related to the number of orders filled. She based this conclusion on the fact that 10 months ago the shipping department added some automated equipment. Furthermore, she believes that using linear regression analysis will improve the forecasts of shipping costs. Cost data for the shipping department have been accumulated for the last 25 weeks. She ran two regression analysis of the data, one using direct labor-hours, and one using the number of cartons shipped. The information from the two linear regressions is the following:
Regression 1
Regression 2
Equation
SC = 804.3 + 15.68 DL
SC = 642.9 + 3.92 NR
R-squared
0.365
0.729
Standard error of the estimate
2.652
1.884
QUESTION 2 (CONTINUED)
Where:
SC = Total shipping department costs
DL = Total direct labour hours
NR = Number of cartons shipped
Required:
a) Identify which regression equation (Regression 1 or Regression 2) that Pacific Air should adopt for forecasting total shipping department costs and explain your reasons. (7 marks)
b) If Pacific Air estimates that 600 orders will be filled in the coming week, calculate the total shipping department costs using the regression that you have selected in part (a). (3 marks)
c) Are there any limitations to the regression that you have selected in part (a) above? If so, identify ways to address the limitations. Include in your answer the effect, if any, of the global nature of Pacific Air Corporation business. (8 marks)
QUESTION 3 HILLVIEW GARDEN CARE INC. (25 marks)
Hillview Garden Care Inc. is a lawn and garden care service. The company originally specialized in serving small residential clients but has recently started contracting for work on large apartment and office building grounds. Since Phyllis Flower (owner) believes that commercial lawn care is more profitable she is considering dropping residential services altogether.
Five field employees worked a total of 20,000 hours last year, 13,000 on residential jobs and 7,000 on commercial jobs. Wages amounted to $9 per hour for all work done. Direct materials used are included in overhead as supplies. All overhead is allocated on the basis of labour-hours worked, which is also the basis for customer charges. Because of the increased competition for commercial accounts, Phyllis can charge $22 per hour for residential work but only $19 per hour for commercial work.
Recently, Phyllis attended an accounting workshop on overhead-costing and activity analysis. She applied what she had learnt on the company. Further analysis revealed that the overheads consist of activities relating to transportation, equipment use and supplies. These costs are attributed to the following cost drivers as shown below:
QUESTION 3 (CONTINUED)
Activity Level
Activity Cost Driver Cost Commercial Residential
Transportation Number of
clients serviced
$8,000 15 45
Equipment Use Equipment
hours
$18,000 3,500 2,100
Supplies Area serviced in
square yards
$36,000 130,000 70,000
Total Overhead $62,000
Required:
a) If the overhead is $62,000, calculate the profits of commercial and residential services using
labour as the allocation base. (7 marks)
b) Recalculate your profits for the commercial and residential services using overhead as the
cost driver.(10 marks)
c) Based on your results for both a) and b), make recommendations to management on what
action to take on both of these services and explain your reasons. (8 marks)
QUESTION 4 ? ELF?s PLACE INC. (18 marks)
Elf?s Place Inc. (Elf?s) sells toys, games and books. A poplar service is the birthday service,
which includes free gift wrapping and delivery of gifts to local families. Elf?s accepts cash,
cheques, Visa, MasterCard, and American Express credit cards. These methods of payment have
the following characteristics:
Cash Payment is immediate; no fee is charged
Cheque Payment is immediate; the bank charges $0.25 per cheque; and
1 percent of cheque revenue is from ?bad? cheques that Elf
cannot collect
Visa/MasterCard Elf accumulates these credit card receipts throughout the month
and submits them in one bundle for payment on the last day of
the month. The money is credited to Elf?s account by the fifth
day of the following month. A fee of 1.50 percent is charged
by the credit card company.
American
Express
Elf accumulates these credit card receipts throughout the month
and mails for payment on the last day of the month. American
Express credit?s Elf?s account by the tenth day of the following
month. A fee of 3.50 percent is charged by American Express.
QUESTION 4 (CONTINUED)
During a typical month, the type of payment used by customers is as follows:
American Express: 20% of sales
Visa/MasterCard: 50% of sales
Cheque: 5% of sales (average cheque is $37.50)
Cash: 25% of sales
Required:
If Elf?s estimates sales of $30,000 in April and $60,000 in May, what are his planned net cash receipts for May? Show your workings. (18 marks)
QUESTION 5 LINK?S FINE BURGERS INC. (20 marks)
Link?s Fine Burgers Inc. (Link?s), is a new company currently studying various alternatives in regard to opening burger outlets. The only available data was formulated by a hired consultant who, unfortunately, left the country suddenly. A summary of the information that the consultant developed is as follows:
Average Selling Price per Pizza $7.50
Normal Monthly Costs
Fixed
Variable
Cost of Burger?s Sold
$0
$5,500
Manager?s Salary
2,000
0
Wages
2,000
0
Rent
1,500
500
Utilities
500
200
Insurance and Commissions
1,000
0
Total Costs
$7,000
$6,200
*Note: Costs are based on budgeted sales of 2,000 burger?s per month.
The above information represents estimates for the operations of a burger outlet. Link?s is interested in opening the outlets as soon as possible and has asked you to comment on the various scenarios as reflected in the questions a thru to c below.
. " .
'
Required:
a) Compute the breakeven point for a burger outlet in terms of both sales dollars and number of burger?s sold each month. (6 marks)
b) The company is considering offering a promotional selling price of $5.00 per burger during the first month of operations. How many extra burger?s will have to be sold by a burger outlet at
QUESTION 5 (CONTINUED)
the promotional price compared to the normal average selling price in order to earn operating income of $2,500 during the first month? (6 marks)
c) As an incentive program for the outlet manager, Link?s is considering implementing an alternative compensation method. Instead of paying the manager a fixed salary of $2,000 per month, the company is considering an incentive plan of $1,000 per month plus 8% of monthly revenue Using this alternative method and the normal average selling price per burger, calculate how many burger?s will have to be sold to achieve an operating income of $2,000 per month.(8 marks)
QUESTION-1 (CONTINUED) Eric: "Linda, my wife would be ecstatic if I were able to improve our financial position as Quickly as this opportunity affords. I certainly hope that you win the bid. What kind of help can I provide?" Linda: "Simple. To win, all I have to do is beat the bid of your firm. Before 1 submit my bid, I would like you to review it. With the financial skills you have, it should be easy for you to spot any excessive costs that I may have included. Or perhaps I included the wrong kind of costs. By cutting excessive costs and eliminating costs that may not be directly related to the project, my bid should be competitive enough to meet or beat your firm's bid." Required: (Please note this answer should not be more than 3 pages maximum) a) What would you do if you were Eric? Explain the reasons for your decision and apply the code of ethics to the proposal given, to Eric assume that Eric is a member of a professional accounting body. (10 marks) b) What is the risk to Eric personally if he reviews the bid? Should the degree of risk influence his decision? Explain your reasons. (9 marks) QUESTION 2 PACIFIC AIR CORPORATION (18 marks) Pacific Air Corporation is a business 'providing a wide variety of aviation products to pilots throughout the world. Dana Lombardi, the recently hired assistant controller, has been asked to develop a cost function to forecast shipping costs. The previous assistant controller had forecasted shipping department costs each year by plotting cost data against; direct labor-hours for the most recent 12 months and visually fitting a straight line through the points. The results were not satisfactory. After discussions with the shipping Regression 2 department personnel, Lombardi decided that shipping costs could be more closely related to the number of orders filled. She based this conclusion on the fact that 10 months ago the shipping department added some automated equipment. Furthermore, she believes that using linear regression analysis will improve the forecasts of shipping costs. Cost data for the shipping department have been accumulated for the last 25 weeks. She ran two regression analysis of the data, one using direct labor-hours, and one using the number of cartons shipped. The information from the two linear regressions is the following: Regression 1 Equation SC = 804.3 + 15.68 DL SC = 642.9 + 3.92 NR R-squared 0.365 0.729 Standard error of the 2.652 1.884 estimateStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started