Question

In: Accounting

1) Bustillo Company operates sight-seeing buses. Management has identified two cost drivers—the number of buses in...

1) Bustillo Company operates sight-seeing buses. Management has identified two cost drivers—the number of buses in operation and the number of passengers served —that it uses in its budgeting and performance reports. Data concerning the company’s cost formulas appear below:

Fixed Cost per Month

Cost per Bus

Cost per Passenger

Vehicle operating costs

$

6,800

$

476

$

4.5

Advertising

$

2,500

Administrative costs

$

5,300

$

38

$

1.5

Insurance

$

3,900

For example, vehicle operating costs should be $6,800 per month plus $476 per bus plus $4.5 per passenger. The company’s sales revenue should average $31 per passenger. In July, the company operated 54 buses and served a total of 3,300 passengers. How much is the company’s flexible budget operating income for July?

2)

A cash budget for the first three quarters of Brister Incorporated is given below (000 omitted). The company requires a minimum cash balance of at least $5,000 to start each quarter. If necessary, the company will borrow money from its bank to maintain this balance. The company will pay no interest in Quarters 1, 2, and 3. It will repay as much of its borrowings as possible as soon as it has more than $5,000 in cash in a given quarter. Suppose the company starts the first quarter with no bank debt. How much total bank debt does the company expect to have at the end of the third quarter?

Cash Budget

Quarter (000 omitted)

1

2

3

Cash balance, beginning

$9

?

?

Add collections from customers

88

127

88

Total cash available

?

?

?

Less disbursements:

Purchase of inventory

55

65

65

Selling and administrative expenses

40

45

51

Equipment purchases

8

10

11

Dividends

2

2

2

Total disbursements

?

?

?

Excess (deficiency) of cash available over disbursements

?

?

?

Financing:

Borrowings

?

?

?

Repayments

?

?

?

Total financing

?

?

?

Cash balance, ending

?

?

?

Solutions

Expert Solution

Ques 1

sales revenue $                  102,300.00
31*3300
vehicle operating costs $                    47,354.00
6800+476*54+4.5*3300
advertising $                       2,500.00
administrative costs $                    12,302.00
5300+38*54+1.5*3300
insurance $                       3,900.00
operating costs $                    66,056.00
operating income $                    36,244.00

Ques 2

cash budget Quarter
1 2 3
cash balance 9 15 5
add:collections from customers 88 127 88
total cash available 97 142 93
less:disbursements
purchase of inventory 55 65 65
selling and administrative expenses 40 45 51
equipment purchases 8 10 11
dividends 2 2 2
total disbursements 105 122 129
excess (deficiency) -8 20 -36
financing:
borrowings 23 41
repayments 15
total financing 23 -15 41
cash balance,ending 15 5 5
Total debt after end of third quarter 49
23-15+41

Related Solutions

Bustillo Company operates sight-seeing buses. Management has identified two cost drivers—the number of buses in operation...
Bustillo Company operates sight-seeing buses. Management has identified two cost drivers—the number of buses in operation and the number of passengers served —that it uses in its budgeting and performance reports. Data concerning the company’s cost formulas appear below: Fixed Cost per Month Cost per Bus Cost per Passenger Vehicle operating costs $ 6,800 $ 476 $ 3 Advertising $ 2,500 Administrative costs $ 5,300 $ 38 $ 1.5 Insurance $ 3,900 For example, vehicle operating costs should be $6,800...
Bustillo Company operates sight-seeing buses. Management has identified two cost drivers—the number of buses in operation...
Bustillo Company operates sight-seeing buses. Management has identified two cost drivers—the number of buses in operation and the number of passengers served —that it uses in its budgeting and performance reports. Data concerning the company’s cost formulas appear below: Fixed Cost per Month Cost per Bus Cost per Passenger Vehicle operating costs $ 6,800 $ 476 $ 4 Advertising $ 2,500 Administrative costs $ 5,300 $ 38 $ 1.5 Insurance $ 3,900 For example, vehicle operating costs should be $6,800...
1. Assume that a company has two cost drivers—number of courses and number of students. The...
1. Assume that a company has two cost drivers—number of courses and number of students. The planned number of courses and students were 5 and 100, respectively. The actual number of courses and students were 6 and 110, respectively. One of the company’s expenses is influenced by both cost drivers and it has a fixed element as well. Its cost formulas are $50 per course, $5 per student, and $1,000 per period. The total actual amount of this expense is...
5) A company has identified the following overhead costs and cost drivers for the coming year:...
5) A company has identified the following overhead costs and cost drivers for the coming year: Overhead Item Cost Driver Budgeted Cost Budgeted Activity Level Machine setup Number of setups $ 20,000 200 Inspection Number of inspections 130,000 6,500 Material handling Number of material moves 80,000 8,000 Engineering Engineering hours 50,000 1,000 Total $280,000 The following information was collected on three jobs that were completed during the year: Job 101 Job 102 Job 103 Direct materials $5,000 $12,000 $8,000 Direct...
Xie Company identified the following activities, costs, and activity drivers for 2015. The company manufactures two...
Xie Company identified the following activities, costs, and activity drivers for 2015. The company manufactures two types of go-karts: Deluxe and Basic.        Activity Expected Costs Expected Activity   Handling materials $ 625,000      100,000 parts   Inspecting product 900,000      1,500 batches   Processing purchase orders 105,000      700 orders   Paying suppliers 175,000      500 invoices   Insuring the factory 300,000      40,000 square feet   Designing packaging   75,000    2 models Assume that the following information is available for the company’s two products...
Xie Company identified the following activities, costs, and activity drivers for 2017. The company manufactures two...
Xie Company identified the following activities, costs, and activity drivers for 2017. The company manufactures two types of go-karts: Deluxe and Basic. Activity Expected Costs Expected Activity Handling materials $ 625,000 100,000 parts Inspecting product 900,000 1,500 batches Processing purchase orders 105,000 700 orders Paying suppliers 175,000 500 invoices Insuring the factory 300,000 40,000 square feet Designing packaging 75,000 2 models Assume that the following information is available for the company’s two products for the first quarter of 2017. Deluxe...
Orange, Inc. has identified the following cost drivers for its expected overhead costs for the year:...
Orange, Inc. has identified the following cost drivers for its expected overhead costs for the year: Total overhead budgeted = $200,000 Total direct labor hours budgeted = 2,000 hours Actual direct labor hours worked on Job 21 = 100 Actual direct materials = $5,000 total Actual direct labor = $3,000 total Actual units completed = 100 The totoal cost of Job 21 is: a. $ 22,500 b. $ 16,000 c. $ 18,000 d. $ 19,900 The Total Cost of Job...
Q1)​A company is considering two location alternatives for a new facility. The management has identified the...
Q1)​A company is considering two location alternatives for a new facility. The management has identified the relevant factors for choosing a location and scored the non-quantitative factors as shown below. FACTOR WEIGHT LOCATION A LOCATION B Labor availability 20 80 95 Supplier network 20 90 85 Quality of life 15 95 100 Initial fixed cost 5 Operating cost 35 Business friendliness 5 50 90 Initial fixed cost and operating cost are quantitative factors. The firm management is undecided about how...
DAB Company has identified the following overhead activities, costs, and activity drivers for the coming year:...
DAB Company has identified the following overhead activities, costs, and activity drivers for the coming year: Activity                                Expected Cost          Activity Driver               Activity Capacity Material-handling costs.. £45,000             Number of moves.........        450 Machine costs................ £80,000             Machine hours.............. 20,000 Order costs.................... £15,000             Number of orders.........        750 Receiving costs.............. £30,000             Number of parts........... 50,000 Setup costs.................... £50,000             Number of setups.........        250 Assume that each activity corresponds to a process. DAB’s normal activity is 5,000 direct labor hours. The following two jobs...
An MNC IT company based in Germany, named IT AG, has identified two mutually exclusive cost...
An MNC IT company based in Germany, named IT AG, has identified two mutually exclusive cost saving projects. However, the equipment that will be required to realize the cost savings need an upfront investment of $250 million for both the projects. The annual cost savings expected from project 1 is 15% of the annual revenues and from project 2 is 12% of the annual revenues. The equipment used in both the projects have a useful life of 4 years. The...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT