Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

Office Plus sells its main product, ergonomic mouse pads, for \(13 each. Its variable cost is \)5.10 per pad. Fixed costs are \(205,000 per month for volumes up to 65,000 pads. Above 65,000 pads, monthly fixed costs are \)250,000. Prepare a monthly flexible budget for the product, showing sales revenue, variable costs, fixed costs, and operating income for volume levels of 45,000, 55,000, and 75,000 pads.

Short Answer

Expert verified

The flexible budget for office plus is prepared with volume levels of 45,000, 55,000 and 75,000 pads.

Step by step solution

01

Definition of flexible budget

A flexible budget is a budget prepared by the company's management that adjusts with any variations in the the activity.

02

Preparation of flexible budget

Flexible Budget

Particulars

Per unit ($)

45,000 ($)

55,000 ($)

75,000 ($)

  1. Sales

13.00

585,000

715,000

975,000

  1. Variable cost

5.10

229,500

280,500

382,500

  1. Contribution Margin

7.90

355,500

434,500

592,500

  1. Fixed Cost

205,000

205,000

250,000

  1. Income/(loss) (C – D)

150,500

229,500

342,500

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Question:Match the product cost variance with the manager most probably responsible. Some answers may be used more than once. Some answers may not be used.

Variance Manager

19. Variable overhead cost variance

20. Direct materials efficiency variance

21. Direct labor cost variance

22. Fixed overhead cost variance

23. Direct materials cost variance

a. Human resources

b. Purchasing

c. Production

Understanding variance relationships

Complete the table below for the missing variances.

Total Flexible Budget Product Cost Variance

(a)

Total direct material variance

(b)

Total direct labor variance

(c)

Total Manufacturing Overhead Variance

(d)

Direct material cost variance

Direct material efficiency variance

Direct Labor Cost Variance

Direct Labor Efficiency Variance

Total Variable Overhead Variance

Total fixed overhead variance

\(310F

\)165U

\(160U

\)415F

(e)

(f)

Variable Overhead Cost Variance

Variable Overhead Efficiency Variance

Fixed Overhead Cost Variance

\(525U

\)575F

$50F

Drew Castello, general manager of Sunflower Manufacturing, was frustrated. He wanted the budgeted results, and his staff was not getting them to him fast enough. Drew decided to pay a visit to the accounting office, where Jeff Hollingsworth was supposed to be working on the reports. Jeff had recently been hired to update the accounting system and speed up the reporting process.

“What’s taking so long?” Drew asked. “When am I going to get the variance reports?” Jeff sighed and attempted to explain the problem. “Some of the variances appear to be way off. We either have a serious problem in production, or there is an error in the spreadsheet. I want to recheck the spreadsheet before I distribute the report.” Drew pulled up a chair, and the two men went through the spreadsheet together. The formulas in the spreadsheet were correct and showed a large unfavorable direct labor efficiency variance. It was time for Drew and Jeff to do some investigating.

After looking at the time records, Jeff pointed out that it was unusual that every employee in the production area recorded exactly eight hours each day in direct labor. Did they not take breaks? Was no one ever five minutes late getting back from lunch? What about clean­up time between jobs or at the end of the day?

Drew began to observe the production laborers and noticed several disturbing items. One employee was routinely late for work, but his time card always showed him clocked in on time. Another employee took 10­ to 15­minute breaks every hour, averaging about 1 hours each day, but still reported eight hours of direct labor each day. Yet another employee often took an extra 30 minutes for lunch, but his time card showed him clocked in on time. No one in the production area ever reported any “down time” when they were not working on a specific job, even though they all took breaks and completed other tasks such as doing clean­up and attending department meetings.

Requirements

1. How might the observed behaviors cause an unfavorable direct labor efficiency variance?

2. How might an employee’s time card show the employee on the job and working when the team member was not present?

3. Why would the employees’ activities be considered fraudulent?

Question:Use the following information to prepare a standard cost income statement for Mitchell Company for 2018.

Cost of Goods Sold (at standard) \( 366,000

Direct Labor Efficiency Variance \) 19,500 F

Sales Revenue (at standard) 570,000

Variable Overhead Efficiency Variance 3,300 U

Direct Materials Cost Variance 7,200 U

Fixed Overhead Volume Variance 12,500 F

Direct Materials Efficiency Variance 2,700 U

Selling and Administrative Expenses 71,000

Direct Labor Cost Variance 42,000 U

Variable Overhead Cost Variance 1,700 F

Fixed Overhead Cost Variance 2,100 F

Question:Give the general formulas for determining cost and efficiency variances.

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free