Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Biloxi Company has provided the following Actual vs Planning Budget report for the month of March. Biloxi uses customers served to measure activity. Biloxi Company

Biloxi Company has provided the following Actual vs Planning Budget report for the month of March. Biloxi uses customers served to measure activity.

Biloxi Company

Actual vs. Planning Budget

For the Month Ended March 31

Actual

Planning

Results

Budget

Variances

Customers served (q)

30,000

28,000

Revenue ($5.00q)

$ 175,000

$ 140,000

$ 35,000

F

Expenses:

Wages and salaries ($35,000 + $1.50q)

80,000

77,000

3,000

U

Supplies ($0.75q)

19,000

21,000

2,000

F

Insurance ($13,000)

13,500

13,000

500

U

Miscellaneous expense ($6,500 + $0.50q)

18,000

20,500

2,500

F

Total expenses

130,500

131,500

1,000

F

Net operating income

$ 44,500

$ 8,500

$ 36,000

F

Required: Prepare the company's flexible budget performance report for March. Label each variance as favorable (F) or unfavorable (U).

Complete the attached schedule:

Biloxi Company

Actual vs. Flexible Budget

For the Month Ended March 31

Revenue and

Variance

Actual

Spending

Indicator

Flexible

Results

Variances

F/U

Budget

Customers served (q)

30,000

Revenue ($5.00q)

$ 175,000

Expenses:

Wages and salaries ($35,000 + $1.50q)

80,000

Supplies ($0.75q)

19,000

Insurance ($13,000)

13,500

Miscellaneous expense ($6,500 + $0.50q)

18,000

Total expenses

130,500

Net operating income

$ 44,500

Input all amounts in the following format: $x,xxx (all amounts other than net operating income will be positive amounts). If you have any variance that are $0, you should enter this as $0 and enter variance indicator as N/A.

Net operating income should be input in the following format: $x,xxx

Net operating loss should be input in the following format: ($x,xxx)

Input all variance indicators as: F (for positive variances) or U (for negative variances)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Proofing Your Return

Authors: Jr. Wade, Jack Warren

1st Edition

002622240X, 978-0026222402

More Books

Students also viewed these Accounting questions