Question

Exercise 10-5 Tarjee Adventures provides tours of scenic locations in Oregon. The company expects tours taken...

Exercise 10-5

Tarjee Adventures provides tours of scenic locations in Oregon. The company expects tours taken to increase dramatically compared with the prior year.

For the past year, 2017, the number of tours given were as follows:

First quarter 7,000
Second quarter 8,000
Third quarter 8,000
Fourth quarter 9,000


Assume that sales for each quarter in 2018 will be 27 percent higher than in 2017 and that the price per tour is $64. Prepare a sales budget by quarter for 2018.

Tarjee Adventures
Sales Budget
For the Year Ending December 31, 2018

First
Quarter

Second
Quarter

Third
Quarter

Fourth
Quarter


Year

Projected sales

Sales price per unit

$ $ $ $ $

Budget revenue for 2018

$ $ $ $ $

Homework Answers

Answer #1
Tarjee Adventures
Sales Budget
For the Year Ending December 31, 2018
First Quarter Second Quarter Third Quarter Fourth Quarter Year
Projected sales            8,890          10,160          10,160          11,430          40,640
Sales price per unit $64 $64 $64 $64 $64
Budget revenue for 2018 $568,960 $650,240 $650,240 $731,520 $2,600,960
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Question 5:                                        &nbs
Question 5:                                                                                                                       10 Marks           Tom’s Tours provides tours of scenic locations in Wilberforce, Ontario. The company expects tours taken to increase dramatically compared with the prior year. For the past year, 2018, the numbers of tours given were as follows: First quarter              8,000 Second quarter         7,000 Third quarter           11,000 Fourth quarter           9,000 Sales for each quarter in 2019 are expected to be 30 percent higher than they were in 2018. The price per tour is $70. Instructions: Prepare a...
company 5 feet by 5 feet wires. To produce one of these wires requires 30 square...
company 5 feet by 5 feet wires. To produce one of these wires requires 30 square feet of copper. Production needs for the year 2017 are as follows: 6,000 units in quarter 1; 7,000 units in quarter 2; 8,000 units in quarter 3; and 9,000 units in quarter 4. First quarter of 2018 expects production of 10,000 units. Each square foot of copper costs $5. Beginning inventory of canvas for the year is 800 square feet. Bob, wants to have...
XYZ Corporation is preparing a master budget for 2018. Sales for the year are expected to...
XYZ Corporation is preparing a master budget for 2018. Sales for the year are expected to total 1,000,000 units. Quarterly sales in units are 20%,25%,30%, and 25% respectively. The sales price is expected to be $50 per unit for the first 3 quarters and $55 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 10% higher than the budgeted sales volume for the first quarter of 2017. Cash collections from sales...
Exercise 23-6 On January 1, 2017, the Hardin Company budget committee has reached agreement on the...
Exercise 23-6 On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2017. Sales units: First quarter 5,300; second quarter 6,000; third quarter 7,800 Ending raw materials inventory: 40% of the next quarter’s production requirements Ending finished goods inventory: 25% of the next quarter’s expected sales units Third-quarter production: 7,360 units. The ending raw materials and finished goods inventories at December 31, 2016, follow the same percentage...
Glob and Dream Company provides the budgeting information for the first two quarters of the coming...
Glob and Dream Company provides the budgeting information for the first two quarters of the coming year 2020; First quarter Second quarter No of sales unit 22,500 unit 20,800 Purchasing costs RM 290,000 RM 350,000 Capital Additions (new machine) RM 250,000 __--------___ Selling and Administrative expenses RM 41,400 RM 46,400 The company expects to sell their units in the first quarter by RM 20 per unit and the price will increase by 25% in the second quarter. Based on the...
The Grilton Tire Company manufactures racing tires for bicycles. Grilton sells tires for $50 each. Grilton...
The Grilton Tire Company manufactures racing tires for bicycles. Grilton sells tires for $50 each. Grilton is planning for next year by developing a master budget by quarters. Grilton’s balance sheet for December 31, 2017 follows: GRILTON TIRE COMPANY Balance Sheet December 31, 2017 Assets Current Assets:    Cash                                                                                            $ 39,000    Accounts Receivable                                                                    40,000    Raw Materials Inventory                                                               2,400    Finished Goods Inventory                                                             8,700    Total Current Assets                                                                                               $ 90,100 Property, Plant and Equipment:    Equipment                                                                                  177,000    Less:...
The Grilton Tire Company manufactures racing tires for bicycles. Grilton sells tires for $50 each. Grilton...
The Grilton Tire Company manufactures racing tires for bicycles. Grilton sells tires for $50 each. Grilton is planning for next year by developing a master budget by quarters. Grilton’s balance sheet for December 31, 2017 follows: GRILTON TIRE COMPANY Balance Sheet December 31, 2017 Assets Current Assets:    Cash                                                                                            $ 39,000    Accounts Receivable                                                                    40,000    Raw Materials Inventory                                                               2,400    Finished Goods Inventory                                                             8,700    Total Current Assets                                                                                               $ 90,100 Property, Plant and Equipment:    Equipment                                                                                  177,000    Less:...
The Grilton Tire Company manufactures racing tires for bicycles. Grilton sells tires for $50 each. Grilton...
The Grilton Tire Company manufactures racing tires for bicycles. Grilton sells tires for $50 each. Grilton is planning for next year by developing a master budget by quarters. Grilton’s balance sheet for December 31, 2017 follows: GRILTON TIRE COMPANY Balance Sheet December 31, 2017 Assets Current Assets:    Cash                                                                                            $ 39,000    Accounts Receivable                                                                    40,000    Raw Materials Inventory                                                               2,400    Finished Goods Inventory                                                             8,700    Total Current Assets                                                                                               $ 90,100 Property, Plant and Equipment:    Equipment                                                                                  177,000    Less:...
Okay Company is preparing to build its master budget. The budget will detail each quarter’s activity...
Okay Company is preparing to build its master budget. The budget will detail each quarter’s activity and the activity for the year in total. The master budget will be based on the following information: a. This will be the first year of operation for Okay Company. b. Budgeted unit sales by quarter for 2019 are projected as follows: First quarter 6,500, Second quarter 6,000, Third quarter 6,100 & Fourth quarter 6,250. First and second quarter 2020 budgeted sales units is...
The Grilton Tire Company manufactures racing tires for bicycles. Grilton sells tires for $50 each. Grilton...
The Grilton Tire Company manufactures racing tires for bicycles. Grilton sells tires for $50 each. Grilton is planning for next year by developing a master budget by quarters. Grilton’s balance sheet for December 31, 2017 follows: GRILTON TIRE COMPANY Balance Sheet December 31, 2017 Assets Current Assets:    Cash                                                                                            $ 39,000    Accounts Receivable                                                                    40,000    Raw Materials Inventory                                                               2,400    Finished Goods Inventory                                                             8,700    Total Current Assets                                                                                               $ 90,100 Property, Plant and Equipment:    Equipment                                                                                  177,000    Less:...