Home / Questions / Scattergraph Analysis Selection of an Activity Base Mapleleaf Sweepers of Toronto manufact...
Scattergraph Analysis; Selection of an Activity Base
Mapleleaf Sweepers of Toronto manufactures replacement rotary sweeper brooms for the large sweeper trucks that clear leaves and snow from city streets. The business is seasonal, with the largest demand during and just preceding the fall and winter months. Because there are so many different kinds of sweeper brooms used by its customers, Mapleleaf Sweepers makes all of its brooms to order.
The company has been analyzing its overhead accounts to determine fixed and variable com- ponents for planning purposes. Below are data for the company’s janitorial labor costs over the last nine months. (Cost data are in Canadian dollars.)
|
January . . . . . . . . . . . . . |
115 |
21 |
$3,840 |
|
February . . . . . . . . . . . . |
109 |
19 |
$3,648 |
|
March . . . . . . . . . . . . . . . |
102 |
23 |
$4,128 |
|
April . . . . . . . . . . . . . . . . |
76 |
20 |
$3,456 |
|
May . . . . . . . . . . . . . . . . |
69 |
23 |
$4,320 |
|
June . . . . . . . . . . . . . . . |
108 |
22 |
$4,032 |
|
July . . . . . . . . . . . . . . . . . |
77 |
16 |
$2,784 |
|
August . . . . . . . . . . . . . . |
71 |
14 |
$2,688 |
|
September . . . . . . . . . . . |
127 |
21 |
$3,840 |
The number of workdays varies from month to month due to the number of weekdays, holi- days, days of vacation, and sick leave taken in the month. The number of units produced in a month varies depending on demand and the number of workdays in the month.
There are two janitors who each work an eight-hour shift each workday. They each can take up to 10 days of paid sick leave each year. Their wages on days they call in sick and their wages during paid vacations are charged to miscellaneous overhead rather than to the janitorial labor cost account.
Required:
1. Plot the janitorial labor cost and units produced on a scattergraph. (Place cost on the vertical axis and units produced on the horizontal axis.)
2. Plot the janitorial labor cost and number of workdays on a scattergraph. (Place cost on the vertical axis and the number of workdays on the horizontal axis.)
3. Which measure of activity—number of units produced or janitorial workdays—should be used as the activity base for explaining janitorial labor cost?
Jun 28 2020 View more View Less
A company wants to purchase a cutting machine now. The price of the machine is $75,000. If the company must pay $3000 uniformly each year, starting from year 6 for 3 year...
May 06 2021describe the major decisions involved in job analysis >
May 04 2020Given a 7 percent interest rate, compute the present value of payments made in years 1, 2, 3, and 4 of $1,800, $2,000, $2,000, and $2,300. Do not round intermediate calcu...
May 19 2018James Watkins, an ambitious 22-year-old, started an entertainment business called Best Club after he graduated from California State University. Best Club initially was a...
Aug 12 2021Name the tree that is used in making parts of bullock cart.
Jul 13 2021Show transcribed image textQUESTION 5 FINANCIAL STATEMENTS (20 MARKS) Menton Enterprises PRE-ADJUSTMENT TRIAL BALANCE AS AT 29 FEBRUARY 2016 Debit (R) The trial balance, ...
Aug 14 2020When the financial system lacks the capability of making judgments about investment opportunities due to asymmetric information, leading to potentially bad credit risks l...
Nov 20 2019Roots and shoots lengthen through activity at ________.a. apical meristems b. lateral meristems c. vascular cambiumd. cork cambium
Jun 07 2021Do you possess any knowledge about accounting standards?
Jul 23 2021Assume the following cost data are for a purely competitive producer.Total Product Average Fixed Cost Average Variable Cost Average Total Cost Marginal Cost 0 $0.00 $0.00...
Apr 30 2020