An airport is looking for some devices to support the luggage transportation services. There are 4 alternatives available (D1, D2, D3 and D4). To assist the evaluations, their purchase costs, service lives, possible salvages at the end of lives have been collected in Table Q2. In addition, the monthly variable costs of using these devices to perform the luggage transportation services in particular, and the numbers of corresponding devices needed are also provided in Table Q2. Given that the internal rate of return is set to 0.8% per month in that case.
(a) What are the Present Values of the end of life salvages (per unit) from these 4 devices? (4 marks)
(b) Determine the Capital Recovery Factors for the calculations of the monthly equivalent fixed costs (per unit) of the 4 devices. (4 marks)
(c) What are the fixed costs (per unit) in a monthly basis of the 4 devices? (4 marks)
(d) Prioritize the preference of choosing these 4 devices based on the cost minimization purpose and order them in the format of A > B > ..., where A is better than B and so on.
(8 marks)
(e) What is the total monthly cost of the most preferred choice for providing the luggage
transportation services?
(5 marks)
Rubrics and Marking:
Table Q2
Device |
D1 |
D2 |
D3 |
D4 |
Purchase Cost ($/unit) |
38000 |
18000 |
35000 |
12000 |
Service Life (years) |
5 |
7 |
8 |
4 |
End of Life Salvage ($/unit) |
2500 |
2000 |
3200 |
3000 |
No. of Devices Required (units) |
1 |
2 |
1 |
3 |
Variable Cost Required ($/month/unit) |
450 |
220 |
380 |
150 |
Device | D1 | D2 | D3 | D4 |
Purchase Cost ($/unit) | 38000 | 18000 | 35000 | 12000 |
Service Life (years) | 5 | 7 | 8 | 4 |
in months(yrs.*12) | 60 | 84 | 96 | 48 |
End of Life Salvage ($/unit) | 2500 | 2000 | 3200 | 3000 |
No. of Devices Required (units) | 1 | 2 | 1 | 3 |
Variable Cost Required ($/month/unit) | 450 | 220 | 380 | 150 |
Total variable cost(per unit*no.of units) | 450 | 440 | 380 | 450 |
PV of annuity of variable costs | ||||
Device | D1 | D2 | D3 | D4 |
A.Purchase Cost ($/unit) | 38000 | 18000 | 35000 | 12000 |
1.Service Life (years) | 5 | 7 | 8 | 4 |
2. in months(yrs.*12) | 60 | 84 | 96 | 48 |
3.End of Life Salvage ($/unit) | 2500 | 2000 | 3200 | 3000 |
(a) Present Values of the end of life salvages (per unit) (Row 3/1.008^Row 2) | 2500/1.008^60= | 2000/1.008^84= | 3200/1.008^96= | 3000/1.008^48= |
1549.92 | 1024.11 | 1489.15 | 2046.52 | |
4.No. of Devices Required (units) | 1 | 2 | 1 | 3 |
5.Variable Cost Required ($/month/unit) | 450 | 220 | 380 | 150 |
6.Total variable cost for the device | 450 | 440 | 380 | 450 |
7.Monthly Capital Recovery Factors (Ans.b) | (1-1.008^-60)/0.008= | (1-1.008^-84)/0.008= | (1-1.008^-96)/0.008= | (1-1.008^-48)/0.008= |
47.50421418 | 60.99331783 | 66.83001785 | 39.72838826 | |
8.PV of variable costs for the device(6*7)(Ans.c) | 21376.89638 | 26837.05985 | 25395.40678 | 17877.77472 |
9.Net PV of costs(A-a+8) | 57826.98 | 43812.95 | 58906.26 | 27831.26 |
10.Equivalent monthly cost(NPV/Factor)(9/7) | 1217.30 | 718.32 | 881.43 | 700.54 |
d..so, from the above | ||||
from cost minimisation point of view, | ||||
D4 > D2> D3 > D1 | ||||
(e) Total monthly cost of the most preferred choice for providing the luggage = $ 700.54 (Uniform Equivalent Monthly Cost for the device D4) |
An airport is looking for some devices to support the luggage transportation services. There are 4...
The last questions choices are customer 1,customer 2, customer 3, customer 4 demand has a shortfall of 2000,4000,6000,8000,10000 customer 1, customer 2, customer 3, customer 4 demand of 2000,4000,6000,8000,10000 Klein Chemicals, Inc., produces a special oil-based material that is currently in short supply, Four of Klein's customers have already placed orders that together exceed the combined capacity of Klein's two plants. Klein's management faces the problem of deciding how many units it should supply to each customer. Because the four...
Hey, I was doing some homework questions and wanted to compare. Thanks! 1)A transportation company provides bussing, limo and taxi service. The company charges: $350 per day for bussing service; $2.00 per kilometre for taxi service; and, $3.50 per kilometre for limo service. Two individual clients, the school board and the city government offices use the majority of the limo service on a contract agreement. Bussing services are used exclusively by the school board, and the taxi service is used...
The Mona Western University operates a Laundromat, solely for the purpose of providing laundering services to students in residence. You have been hired as an accounting student, to analyze the cost of the laundering services. The university administration has assembled the data for a twelve month period pertaining to the monthly total costs of providing the service and the corresponding number of students who used the laundering facilities each month. The table below shows the monthly data collected over the...
The Mona Western University operates a Laundromat, solely for the purpose of providing laundering services to students in residence. You have been hired as an accounting student, to analyze the cost of the laundering services. The university administration has assembled the data for a twelve month period pertaining to the monthly total costs of providing the service and the corresponding number of students who used the laundering facilities each month. The table below shows the monthly data collected over the...
ARTB Mona Western University operates a Laundromat, solely for the purpose of providing ering services to students in dance. You have been hired as an accounting ouder. wlyze the cost of the laundering services. The university administration has assembled me dats welve month period pertaining to the monthly total cost of providing the service and the corresponding number of students who used the laundering faolinties each month The table below shows the monthly data collected over the academic year under...
Question 4: Activity Based Costing (20 marks in total) Black and Hollis perform consulting services related to e-commerce and information systems, in Adelaide. The firm, which bills $187.50 per hour for services performed, is in a very tight labour market and is having difficulty finding quality staff. The labour cost per hour paid by Black and Hollis for professional staff time is $67.50. Selected information follows: Billable hours for clients for the year totalled 5,000, consisting of information systems services,...
Ground Entertainment is a provider of cable, Internet, and on-demand video services. Ground currently sends monthly bills to its customers via the postal service. Because of a concern for the environment and recent increases in postal rates, Ground 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 wastedisposal, and reduced transportation needs.) Although Ground would like...
Complete the income statement. Bug-Off Exterminators provides pest control services and sells extermination products manufactured by other companies. Following is the company's unadjusted trial balance as of December 31, 2019. December 31, 2019 Unadjusted Trial Balance $ 17,000 4,000 $ 828 11,700 32,000 45,000 12,200 5,000 1,400 15,000 59,700 10,000 Cash Accounts receivable Allowance for doubtful accounts Merchandise inventory Trucks Accum. depreciation-Trucks Equipment Accum. depreciation-Equipment Accounts payable Estimated warranty liability Unearned services revenue Interest payable Long-term notes payable D. Buggs,...
Comprehensive Problem Bug-Off Exterminators Bug-Off Exterminators provides pest control services and sells extermination products manufactured by other companies. Following is the company's unadjusted trial balance as of December 31, 2013. BUG-OFF EXTERMINATORS December 31, 2013 Unadjusted Trial Balance Cash $ 17,900 Accounts receivable 5,900 Allowance for doubtful accounts $ 814 Merchandise inventory 13,100 Trucks 31,620 Accum. depreciation—Trucks 0 Equipment 47,770 Accum. depreciation—Equipment 13,800 Accounts payable 6,500 Estimated warranty liability 1,310 Unearned services revenue 0 Interest payable 0 Long-term notes...
Complete SOE. Bug-Off Exterminators provides pest control services and sells extermination products manufactured by other companies. Following is the company's unadjusted trial balance as of December 31, 2019. December 31, 2019 Unadjusted Trial Balance $ 17,000 4,000 $ 828 11,700 32,000 45,000 12,200 5,000 1,400 15,000 59,700 10,000 Cash Accounts receivable Allowance for doubtful accounts Merchandise inventory Trucks Accum. depreciation-Trucks Equipment Accum. depreciation-Equipment Accounts payable Estimated warranty liability Unearned services revenue Interest payable Long-term notes payable D. Buggs, Capital D....