ABC

Module Problem

Due: March 10 no later than 11:55 p.m.

Note: There are two problems here. You must do them both to receive full credit on this module problem.

Part 1. This problem relates to ABC Firm, from last week's module problem, so some of the information may seem familiar. The firm has become increasingly concerned about its cost information and is considering implementing an ABC system. After much research, 3 pools have been identified: materials handling (cost driver is DM$), machining (cost driver is MH) and finishing (cost driver is DLH). Information to support the new system follows:

EstimatesActuals

Direct labour hours41,00043,480

Machine hours207,000196,600

Direct labour$732,000$792,310

Direct materials863,000858,200

Materials handling costs334,000392,000

Machining1,140,0001,078,400

Finishing983,0001,020,800

On June 17, Job 403 was begun. It was completed on July 30. It required 5,400 machine hours and 960 DLH. Direct manufacturing costs were DM of $7,800 and DL of $21,210.

The job sold for $125,000.

On November 11, Job 890 was begun. It was completed on November 21. It required 3,700 machine hours and 1,250 DLH. Direct manufacturing costs were DM of $7,400 and DL of $28,500. The job sold for $130,000.

1.Assuming the firm uses the new ABC system, compute the costs of Jobs 403 and 890.

Part 2.

Happy Days provides tours to locations all over South America. Some of its most popular destinations include Macchu Picchu, the Galapagos Islands, Patagonia and Easter Island. The firm caters to groups of five or more and takes care of all arrangements from start to finish. Happy Days arranges for flights to the location, books accommodations, arranges for meals that meet the group's interests and specifications, and provides sightseeing with a local guide. Due to its policy of maintaining strong personal contact with all clients, the firm requires that there can be no more than 8 people per guide.

The firm uses an ABC system to determine the cost of each tour. Flights to the locations (since they can originate all over the world) are treated as direct costs. All other costs are indirect, since they are the result of extensive contracts that determine costs for all tours. There are three cost pools.Accommodations, which include the hotel rooms, all transfers between the hotels and airports and any relates tips or port charges. The cost driver is number of couple/days (number of couples times number of days). If any person in the group will not share a room, that person is counted as a couple.The food cost pool includes all food for the entire tour, including tips, transportation, carefully chosen beverages and meal-time entertainment. The cost driver is person/days (number of people times number of days). The sightseeing cost pool includes all transportation to the activities chosen by the group, any admission fees, the cost of the guides and carefully chosen souvenirs that are intended to remind the group of their vacation. The cost driver is guide/days (number of guides for group times number of days of tour).

For the upcoming summer season, the following estimates have been made:

Number of tours75

Average duration of tour5 days

Average number in group10 people

Average rooms per group6 rooms

Cost of flights$450,000

Food cost592,000

Accommodations389,000

Sight-Seeing 365,000

The Jones family (there are 19 of them) has booked a tour to Machu Picchu. They will fly into Cuzco from Vancouver, San Francisco and Halifax to meet their guides. The cost of their flights will total $6,230. They will then travel to Aguas Calientes where they will stay for 8 days. During that time, they will visit Machu Picchu 5 times and take two-day hikes along the Inca trail complete with llama pack animals and wine and cheese picnics. Five people in the party do not wish to share rooms.

1. What is the estimated cost of the average group served by Happy Days? Hint: do not make this complicated. It is an easy computation.

2. What is the cost of the Jones tour based on the ABC system?