Question

In: Accounting

Data from the duplicating department of Fastcopy Ltd for the 5 months are as follow: Month...

Data from the duplicating department of Fastcopy Ltd for the 5 months are as follow:

Month #Copies   Dept Costs

January    14,800 $12,830

February 16,000     13,930

March    20,000     17,300

April     23,600     19,430

May     18,500     15,800

What are the expected duplicating department costs for June if 19,000 copies are expected to be made?

$15,858

$15,980

$16,216

$18,580

Solutions

Expert Solution

  • Working

Months

Units

Cost

High Level

April

                          23,600

$                   19,430.00

Low Level

January

                          14,800

$                   12,830.00

Difference

                            8,800

$                     6,600.00

A

Difference in Cost

$                     6,600.00

B

Difference in units

                              8,800

C = A/B

Variable cost per unit

$                             0.75

Working

High Level

Low Level

A

Total Cost

$                 19,430.00

$                   12,830.00

B

Total Units

23600

14800

C

Variable cost per unit

$                          0.75

$                             0.75

D = B x C

Total Variable cost

$                 17,700.00

$                   11,100.00

E = A - D

Total Fixed Cost

$                   1,730.00

$                     1,730.00

  • Cost of 19000 copies
    = $ 1730 + ($0.75 x 19000)
    = 1730 + 14250
    = $ 15,980
  • Correct Answer = Option #2: $ 15,980

Related Solutions

The following data apply to Zabra Ltd in its mixing department for the month of September....
The following data apply to Zabra Ltd in its mixing department for the month of September. All raw materials are fully added at the beginning of the production process and conversion occurs uniformly throughout the production process. On 1 September 2019, Zabra had work in process comprised of 10,000 units. These units were 20 percent complete in terms of conversion. The table below presents the cost data for work in process inventory (WIP) and costs incurred for the production during...
1.      The demand data for a product over the past 5 months are shown below: MONTH...
1.      The demand data for a product over the past 5 months are shown below: MONTH DEMAND (number of units sold) Five months ago 51 Four months ago 58 Three months ago 63 Two months ago 71 Last month 77 a.      Plot the monthly demand data using a software OR on a sheet of graph paper. b.      Use TREND PROJECTIONS method to determine the equation of the trend line estimating the linear relationship between time (in months) and demand (in...
A sample of 5 months of sales data provided the following information: Month 1 2 3...
A sample of 5 months of sales data provided the following information: Month 1 2 3 4 5 Units Sold 96 110 85 96 93 Develop a point estimate of the population mean number of units sold per month (to 1 decimal). Develop a point estimate of the population standard deviation (to 2 decimals).
A simple random sample of 5 months of sales data provided the following information: Month: 1...
A simple random sample of 5 months of sales data provided the following information: Month: 1 2 3 4 5 Units Sold: 94 85 85 94 92 (a) Develop a point estimate of the population mean number of units sold per month. x = (b) Develop a point estimate of the population standard deviation. If required, round your answer to two decimal places. s =
The following table contains the demand from the last 5 months. Month Actual Demand 1 25...
The following table contains the demand from the last 5 months. Month Actual Demand 1 25 2 30 3 33 4 35 5 38 Calculate the single exponential smoothing forecast for these data using an α of 0.3 and an initial forecast (F1) of 28. Report the forecast for Month 6 in AnswerSheet. Show your work in worksheet “Show your work for Q1.” (2 pts.) Calculate the exponential smoothing with trend forecast for these data using an α of 0.25,...
The accounting department needs to forecast the profit for a subsidiary. The data for several months...
The accounting department needs to forecast the profit for a subsidiary. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is exponential smoothing with trend accounting for seasonality given a smoothing constant (alpha) of 0.69, a trend smoothing constant (delta) of 0.3, a previous trend amount, seasonally adjusted, of 65, and a previous seasonal forecast of 582. Please round your forecast to...
Selected transactions follow for Covington Sports Ltd. during the company’s first month of business. The company...
Selected transactions follow for Covington Sports Ltd. during the company’s first month of business. The company expects a return rate of 8% and uses a perpetual inventory system. Feb. 2 Sold $1,135 of merchandise to Andrew Noren on account, terms n/30. The goods had cost Covington $758. 4 Andrew Noren returned for credit $141 of the merchandise purchased on February 2. The goods had cost Covington $84 and they were returned to inventory. 5 Sold $762 of merchandise to Dong...
Work in Process Account Data for Two Months; A report prepared periodically by a processing department,...
Work in Process Account Data for Two Months; A report prepared periodically by a processing department, summarizing (1) the units for which the department is accountable and the disposition of those units and (2) the costs incurred by the department and the allocation of those costs between completed and incomplete production.Cost of Production Reports Pittsburgh Aluminum Company uses a A type of cost system that accumulates costs for each of the various departments within a manufacturing facility.process cost system to...
Manufacturing data for January and February in the Mixing Department of Klinger Kleaning Products follow: January...
Manufacturing data for January and February in the Mixing Department of Klinger Kleaning Products follow: January February Material used $20,000 $28,400 Labor $15,200 $23,000 Factory overhead $11,400 $19,800 Finished and transferred to Blending Dept. 3,600 3,200 Work in process, end of month 400 600 Stage of completion 3/4 1/4 All materials are added at the start of the process. Labor and factory overhead are added evenly throughout the process. No units were in process at the beginning of January. Goods...
The budget for Department 5 of Plant M for the current month ending March 31 is...
The budget for Department 5 of Plant M for the current month ending March 31 is as follows: Materials $206,000 Factory wages 265,000 Supervisory salaries 67,800 Depreciation of plant and equipment 35,000 Power and light 22,500 Insurance and property taxes 15,500 Maintenance 9,700 During March, the costs incurred in Department 5 of Plant M were materials, $204,000; factory wages, $285,000; supervisory salaries, $63,600; depreciation of plant and equipment, $35,000; power and light, $21,360; insurance and property taxes, $14,400; maintenance, $9,456....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT