T&P Fashion Shops is a new chain that operates 10 stores in major malls throughout the United States. Each store manager is responsible for...
View the step-by-step solution to:

Question

How do I figure out the Flexible budget excel column? T&P Fashion</h1><p class='abPRemoveTitle'> .jpg

T&P Fashion .jpg

T&amp;P Fashion Shops is a new chain that operates 10 stores in major malls throughout the United States.
Each store manager is responsible for preparing a flexible budget for the store. T&amp;P headquarters
accumulates and analyzes the information for each store and in the aggregate.
Below is the forecast (budgeted income statement) for the Houston store showing the breakdown of fixed
and variable expenses in columns two through four. The last column shows the actual results.
T&amp;P Fashions - Houston Store
Breakdown of Expenses (Forecast)
Forecast
Fixed
Variable
Actual
Revenues
$1,400,000
$1,260,000
Cost of Sales
790,000
790,000
760,000
Gross Profit
$610,000
$500,000
Management
182,000
154.700
27,300
182,000
Shop assistants
258,000
154,800
103,200
262,000
Rent
23,200
18,560
4,640
22,000
Utilities
34,800
34,800
31,000
Misc. expenses
24,500
12.250
12.250
28,000
Total expenses
$522.500
$526,000
Net income
$87.500
$(26,000)
Additional Information
. Variable expenses are based on revenues and we assume that the percentage remains constant for
flexible budgeting purposes.
Fixed costs are all within the relevant range.
Other expenses are all specific to this store. Headquarters pay for marketing and corporate overhead
expenses
Case Assignment
Required:
Computations (use Excel)
1. Prepare a flexible budget and show variances for the year that passed. Indicate whether the flexible
budget variances are favorable or unfavorable.
2. Headquarters are contemplating charging each store a 5% marketing expense based on sales. How
will that affect the operating profit of the store and the money available for managerial bonuses based
on actual results for the past year? Summarize the information in a table.
Memo (use Word)
Write a 4- or 5-paragraph memo to the division manager explaining the flexible budget variances; how to
interpret the information and what action, if any to take. Comment on the 5% marketing proposal too. Start
with an introduction and end with a recommendation. Each of the four or five paragraphs should have a
heading.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes