Question

In: Accounting

Cycle Fit Company is a manufacturer of commercial grade exercise bikes that are sold to hotels...

Cycle Fit Company is a manufacturer of commercial grade exercise bikes that are sold to hotels and health clubs. Maintaining the bikes is an important area of customer satisfaction. Because of increase industry​ competition, Cycle Fit​'s financial performance has suffered.​ However, the introduction of a new model and a predicted upturn in the economy are leading Cycle Fit​'s managers to predict improved performance in 2021. The following income statement shows results for 2020.

Cycle Fit Company Income Statement for the Year Ended December​ 31, 2020 ​(in thousands)

Revenues:

Equipment

$8,500

Maintenance contracts

1,400

Total revenues

$9,900

Cost of goods sold

4,200

Gross margin

5,700

Operating costs

Marketing

630

Distribution

180

Customer maintenance

1,900

Administration

990

Total operating costs

3,700

Operating income

$2,000

Cycle Fit​'s management team is preparing the 2021 budget and is studying the following​ information:

1.

Selling prices of bikes are expected to increase by 15​% due to the introduction of the new model. The selling price of each maintenance contract is expected to remain unchanged from 2020.

2.

Bike sales in units are expected to increase by 8​%,
with a corresponding 8​% growth in units of maintenance contracts.

3.

Cost of each unit sold is expected to increase by 5​% to pay for the necessary technology and quality improvements for the new model.

4.

Marketing costs are expected to increase by $230​,000.

5.

Distribution costs vary in proportion to the number of bikes sold.

6.

One additional maintenance technician is to be hired at a total cost of $190​,000, which covers wages and related travel costs. The objective is to improve customer service and shorten response time.

7.

There are no anticipated changes to adminstration costs.

8.

There is no beginning or ending inventory of equipment.

1.

Prepare a budgeted income statement for the year ending December​ 31, 2021.

2.

How well does the budget align with Cycle Fit​'s ​strategy?

3.

How does preparing the budget help Cycle Fit​'s management team better manage the​ company?

Solutions

Expert Solution

1) Budgeted Income Statement for the year ended 31st December 2021
Particulars $ ( in thousands)
Revenue:
Equipment (8500x1.15x1.08) 10557
Maintenance Contracts (1400x1.08) 1512
Total Budgeted Revenue 12069
Cost of goods sold (4200x1.08x1.05) 4762.8
Gross Margin 7306.2
Operating costs
Marketing (630+230) 860
Distribution (180x1.08) 194.4
Customer Maintenance (1900+190) 2090
Adminstration 990
Total Budgeted Operating Costs 4134.4
Budgeted Operating Income 3171.8

2) The budget prepared above shows an increase in the operating income of the company. Cycle Fit's strategy is to introduce a new model and take advantage of the predicted upturn in the economy to improve its performance. Here the budget shows an increase in the revenue due to equipment which confirms new models positive impact on the income of the company.

3) Preparing the budget helps the Cycle Fits management team better mange the company by giving a better idea of what is acheivable and what is likely to happen in  forthcoming period. Also helps in planning to control the costs which are avoidable or which can be reduced. Budget also provides motivation by anticipating the achievable income.


Related Solutions

*Merriweather Corporation is a manufacturer of tables sold to schools, restaurants, hotels, and other institutions. The...
*Merriweather Corporation is a manufacturer of tables sold to schools, restaurants, hotels, and other institutions. The table tops are manufactured by Merriweather, but the table legs are purchased from an outside supplier. The Assembly Department takes a manufactured table top and attaches the four purchased table legs. It takes 20 minutes of labor to assemble a table. The company follows a policy of producing enough tables to ensure that 40% of next month's sales are in the finished goods inventory....
Ingles Corporation is a manufacturer of tables sold to schools, restaurants, hotels, and other institutions. The...
Ingles Corporation is a manufacturer of tables sold to schools, restaurants, hotels, and other institutions. The table tops are manufactured by Ingles, but the table legs are purchased from an outside supplier. The Assembly Department takes a manufactured table top and attaches the four purchased table legs. It takes 16 minutes of labor to assemble a table. The company follows a policy of producing enough tables to ensure that 40 percent of next month's sales are in the finished goods...
Ike’s Bikes is a major manufacturer of bicycles. Currently, the company produces bikes using only one...
Ike’s Bikes is a major manufacturer of bicycles. Currently, the company produces bikes using only one factory. However, it is considering expanding production to two or even three factories. The following table shows the company’s short-run average total cost (SRATC) each month for various levels of production if it uses one, two, or three factories. (Note: Q equals the total quantity of bikes produced by all factories.) Average total cost (dollars per bike) # of factories Q=25 Q=50 Q=75 Q=100...
Consider the following scenario: An electronics manufacturer produces a range of consumer and commercial grade electronic...
Consider the following scenario: An electronics manufacturer produces a range of consumer and commercial grade electronic devices. These include television sets, sound systems, computer monitors, mobile phones and many other products. Each of these products has a name and a unique ID number associated with them. Components to make these devices can be purchased from a single vendor or from multiple vendors. Each component has a name, unique ID number and may include a component description (this information is optional)....
Ike’s Bikes is a major manufacturer of bicycles. Currently, the company produces bikes using only one factory
5. Costs in the short run versus in the long runIke’s Bikes is a major manufacturer of bicycles. Currently, the company produces bikes using only one factory. However, it is considering expanding production to two or even three factories. The following table shows the company’s short-run average total cost (SRATC) each month for various levels of production if it uses one, two, or three factories. (Note: Q equals the total quantity of bikes produced by all factories.)Number of FactoriesAverage Total...
Fogle Florist specializes in large floral bouquets for hotels and other commercial spaces. The company has...
Fogle Florist specializes in large floral bouquets for hotels and other commercial spaces. The company has provided the following data concerning its annual overhead costs and its activity based costing system:   Overhead costs:   Wages and salaries $159,000   Other expenses 62,000   Total $221,000   Distribution of resource consumption:    Activity Cost Pools    Making Bouquets Delivery Other Total   Wages and salaries 45%     20%     35%     100%      Other expenses 45%     50%     5%     100%    The "Other" activity...
Case Study 2: “Mike the Bike” Company produces mountain bikes and sells them to its commercial...
Case Study 2: “Mike the Bike” Company produces mountain bikes and sells them to its commercial customers, which are 20 retail outlets. Of the 20 retail outlets, 19 commercial customers are small bike shops, which are owned separately and one (1) large retail chain with numerous retail outlet stores. The retail chain central purchasing buys 60% of the bicycles produced by Mike the Bike Company, which are warehoused centrally and distributed to its outlets at the large retail chain’s expense....
Ike’s Bikes is a major manufacturer of bicycles. Currently, the company produces bikes using only one factory. However, it is considering expanding production to two or even three factories.
Costs in the short run versus in the long runIke’s Bikes is a major manufacturer of bicycles. Currently, the company produces bikes using only one factory. However, it is considering expanding production to two or even three factories. The following table shows the company’s short-run average total cost (SRATC) each month for various levels of production if it uses one, two, or three factories. (Note: Q equals the total quantity of bikes produced by all factories.)Number of FactoriesAverage Total Cost(Dollars...
Read Book Company is the manufacturer of of exercise machines and is considering producing a new...
Read Book Company is the manufacturer of of exercise machines and is considering producing a new line of equipment in an effort to increase its market share. The new production line will cost $850,000 for manufacturing the parts and an additional $280,000is needed for installation. The equipment falls into the MACRS 3-yr class, and would be sold after four years for $350,000. The equipment line will generate additional annual revenues of $600,000, and will have additional annual operating expenses of...
Read Book Company is the manufacturer of of exercise machines and is considering producing a new...
Read Book Company is the manufacturer of of exercise machines and is considering producing a new line of equipment in an effort to increase its market share. The new production line will cost $850,000 for manufacturing the parts and an additional $280,000is needed for installation. The equipment falls into the MACRS 3-yr class, and would be sold after four years for $350,000. The equipment line will generate additional annual revenues of $600,000, and will have additional annual operating expenses of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT