Question

In: Accounting

URGERNT Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total paper, toner, printer maintenance, and postage...

URGERNT

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Total paper, toner, printer

maintenance, and postage costs . . .

$633,000

$645,000

$780,000

$660,000

Total number of bills mailed . . . . . . . . . .

545,000

585,000

720,000

600,000

1.

Calculate the variable cost per bill mailed under the current​ paper-based billing system.

2.

Assume that the company projects that it will have a total of 800,000 bills to mail in the upcoming quarter. If enough customers choose the paperless billing option so that 25​% of the mailings can be converted to​ paperless, how much would the company save from the paperless billing system​ (be sure to consider the cost of the paperless billing​ system)?

3.

What if only 5​% of the mailings are converted to the paperless option​ (assume a total of 800,000 ​bills)? Should the company still offer the paperless billing​ system? Explain your rationale.

Sky Entertainment is a provider of​ cable, Internet, and​ on-demand video services. Sky currently sends monthly bills to its customers via the postal service. Because of a concern for the environment and recent increases in postal​ rates, Sky management is considering offering an option to its customers for paperless billing. In addition to saving​ printing, paper, and postal​ costs, paperless billing will save energy and water​ (through reduced paper​ needs, reduced waste​ disposal, and reduced transportation​ needs.) While Sky would like to switch to​ 100% paperless​ billing, many of its customers are not comfortable with paperless billing or may not have Web​ access, so the paper billing option will remain regardless of whether Sky adopts a paperless billing system or not.

The cost of the paperless billing system would be $112,800 per quarter with no variable costs since the costs of the system are the salaries of the clerks and the cost of leasing the computer system. The paperless billing system being proposed would be able to handle up to 1,040,000 bills per quarter​ (more than 1,040,000 bills per quarter would require a different computer system and is outside the scope of the current situation at Sky​.) Sky has gathered its cost data for the past year by quarter for​ paper, toner​ cartridges, printer maintenance​ costs, and postage costs for the billing department. The cost data is as​ follows:

Requirement 1. Calculate the variable cost per bill mailed under the current​ paper-based billing system.

Using the​ high-low method, the variable cost per bill mailed under the current​ paper-based billing system is ​$...? .

Requirement 2. Assume that the company projects that it will have a total of 800,000 bills to mail in the upcoming quarter. If enough customers choose the paperless billing option so that 25​% of the mailings can be converted to​ paperless, how much would the company save from the paperless billing system​ (be sure to consider the cost of the paperless billing​ system)?The company would save ​$........? from using the paperless billing system.

Requirement 3. What if only 15​% of the mailings are converted to the paperless option​ (assume a total of 800,000 ​bills)? Should the company still offer the paperless billing​ system? Explain your rationale. ​(Enter any losses as a positive​ number.) If only 15​% of the mailings are converted to the paperless​ option, the company ......? should continue to should no longer offer the paperless billing system because the company ........? loses saves ​$......? from using the paperless billing system.

Solutions

Expert Solution

1. Using the High-low method
Variable cost per bill mailed under the current​ paper-based billing system=
(780000-633000)/(720000-545000)=
0.84
2..25% converted to paperless:
Costs under the current​ paper-based billing system =800000*0.84= 672000
Under 25% paper less opted:
costs for 25%*800000=200000 112800
Costs for balance 600000*0.84 504000
Total costs for 25% opted for paper-less 616800
Savings in costs=(672000-616800)= 55200
3..Only 15% converted to paperless:
Costs under the current​ paper-based billing system =800000*0.84= 672000
Under 15% paper less opted:
costs for 15%*800000=120000 112800
Costs for balance 680000*0.84 571200
Total costs for 15% opted for paper-less 684000
Loss in costs=(672000-684000)= 12000
If only 15​% of the mailings are converted to the paperless​ option, the company SHOULD NO LONGER offer the paperless billing system because the company LOSES from using the paperless billing system.

Related Solutions

The lifetime (in weeks) of printer toner cartridges is normally distributed with mean 4 and variance...
The lifetime (in weeks) of printer toner cartridges is normally distributed with mean 4 and variance 1.5. A consumer buys a number of these cartridges with the intention of replacing them successively as soon as they become empty. The cartridges have independent lifetimes. The cartridges with lifetimes exceeding 5 weeks are classified as “satisfactory”. (a) Find the approximate 95th percentile for the distribution of the life time of printer toner cartridges. (b) What is the probability that a randomly selected...
  Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2   Budgeted unit sales...
  Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2   Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000   Selling price per unit $7 per unit             1 Chapter 7: Applying Excel 2 3 Data Year 2 Quarter Year 3 Quarter 4 1 2 3 4 1 2 5 Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000 6 7 � Selling price per unit $8 per unit 8 � Accounts receivable, beginning balance...
Chapter 9: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1...
Chapter 9: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 • Selling price per unit $8 per unit • Accounts receivable, beginning balance $65,000 • Sales collected in the quarter sales are made 75% • Sales collected in the quarter after sales are made 25% • Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter • Finished...
Chapter 8: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1...
Chapter 8: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales        40,000         60,000      100,000      50,000         70,000         80,000 • Selling price per unit $8 per unit • Accounts receivable, beginning balance $65,000 • Sales collected in the quarter sales are made 75% • Sales collected in the quarter after sales are made 25% • Desired ending finished goods inventory is 30% of the budgeted unit sales...
Division Profitability Quarter 1 Quarter 2 Quarter 3 Quarter 4 graph GROSS PROFIT Revenues 0 0...
Division Profitability Quarter 1 Quarter 2 Quarter 3 Quarter 4 graph GROSS PROFIT Revenues 0 0 1,056,604 1,597,853 - Rebates 0 0 16,500 23,750 - Cost of Goods Sold 0 0 410,486 581,268 = Gross Profit 0 0 629,618 992,835 EXPENSES Store Leases 0 0 90,000 144,000 + Sales and Service Personnel Expense 0 0 99,571 149,429 + Brand Promotions 0 0 0 0 + Special Programs 0 0 0 0 + Ad Creation/Revision 0 0 24,000 12,000 + Point...
Year Quarter Sales 1 1 10 1 2 31 1 3 43 1 4 16 2...
Year Quarter Sales 1 1 10 1 2 31 1 3 43 1 4 16 2 1 11 2 2 33 2 3 45 2 4 17 3 1 13 3 2 34 3 3 48 3 4 19 4 1 15 4 2 37 4 3 51 4 4 21 a. Construct a time series plot. What type of pattern exists in the data? b. Use the following dummy variables to develop an estimated regression equation to account for...
Year Quarter SPeClty 2006 3 4480.77 4 5827.48 2007 1 5602.84 2 5269.74 3 4945.67 4...
Year Quarter SPeClty 2006 3 4480.77 4 5827.48 2007 1 5602.84 2 5269.74 3 4945.67 4 5124.22 2008 1 4996.31 2 5147.61 3 4903.32 4 4960.84 2009 1 4864.16 2 4785.21 3 4684.43 4 4732.58 2010 1 4947.63 2 4826.21 3 4801.46 4 4789.05 2011 1 4812.69 2 4787.65 3 4871.31 4 4756.61 2012 1 4583.15 2 4659.09 3 4587.55 4 4746.01 2013 1 4556.63 2 4632.57 3 4561.03 4 4719.49 2014 1 4516.85 2 4592.78 3 4521.24 4 4844.6...
unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 14,000 in quarter 3;...
unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 14,000 in quarter 3; and 18,000 in quarter 4. Management desires to have an ending finished goods inventory equal to 10% of the next quarter's expected unit sales. What is budgeted production in units for quarter 2?
SE-FamilySize 1 1 4 3 2 4 2 3 4 2 4 1 4 2 2...
SE-FamilySize 1 1 4 3 2 4 2 3 4 2 4 1 4 2 2 4 5 4 5 4 4 2 4 3 1 2 3 5 5 5 Make a confidence interval. Be sure you show all the steps you took. Include a screen shot of any applet you used in your calculations. 2. Choose a confidence level (1 – α). 3. What is xbar? 4. What is s? 5. What is t? (Show a screen shot...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 4...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 4 5 2 4 5 8 3 1 3 4 4 7 9 10 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) - Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item 1 What type of pattern exists in the data? - Select your answer -Positive trend pattern, no seasonalityHorizontal pattern, no seasonalityNegative trend pattern, no seasonalityPositive trend pattern, with seasonalityHorizontal pattern, with...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT