Concept explainers
Preparing an operating budget—sales, production, direct materials, direct labor,
The Irwin Batting Company manufactures wood baseball bats Irwin’s two primary products are a youth bat, designed for children and young teens, and an adult bat, designed for high school and college-aged players. Irwin sells the bats to sporting goods stores, and all sales are on account. The youth bat sells for $35; the adult bat sells for $50. Irwin’s highest sales volume is in the first three months of the year as retailers prepare for the spring baseball season. Irwin’s
Other data for Irwin Batting Company for the first quarter of 2019:
- a. Budgeted sales are 1,400 youth bats and 3,300 adult bats.
- b. Finished Goods Inventory on December 31, 2018, consists of 700 youth bats at $15 each and 550 adult bats at $10 each.
- c. Desired ending Finished Goods Inventory is 220 youth bats and 300 adult bats; FIFO inventory costing method is used.
- d. Direct materials requirements are 40 ounces of wood for youth bats and 70 ounces of wood for adult bats. The cost of wood is $0.10 per ounce.
- e. Raw Materials Inventory on December 31, 2018, consists of 90,000 ounces of wood at $0.10 per ounce.
- f. Desired ending Raw Materials Inventory is 90,000 ounces (indirect materials are insignificant and not considered for budgeting purposes).
- g. Each bat requires 0.4 hours of direct labor; direct labor costs average $26 per hour.
- h. Variable manufacturing overhead is $0.30 per bat.
- i. Fixed manufacturing overhead includes $1,300 per quarter in
depreciation and $14,977 per quarter for other costs, such as insurance and property taxes. - j. Fixed selling and administrative expenses include $13,000 per quarter for salaries; $3,500 per quarter for rent; $1,400 per quarter for insurance; and $450 per quarter for depreciation.
- k. Variable selling and administrative expenses include supplies at 1% of sales.
Requirements
- 1. Prepare Irwin’s sales budget for the first quarter of 2019.
- 2. Prepare Irwin’s production budget for the first quarter of 2019.
- 3. Prepare Irwin’s direct materials, direct labor budget, and manufacturing overhead budget for the first quarter of 2019. Round the predetermined overhead allocation rate to two decimal places. The overhead allocation base is direct labor hours.
- 4. Prepare Irwin’s cost of goods sold budget for the first quarter of 2019.
- 5. Prepare Irwin’s selling and administrative expense budget for the first quarter of 2019.
Want to see the full answer?
Check out a sample textbook solutionChapter 22 Solutions
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
Additional Business Textbook Solutions
Financial Accounting
Fundamentals Of Financial Accounting
Managerial Accounting: Creating Value in a Dynamic Business Environment
Managerial Accounting: Tools for Business Decision Making
Intermediate Accounting
Financial Accounting, Student Value Edition (5th Edition)
- Shand Pipes offers three types of valves for sale to retailers: Ball Valves, Butterfly Valves and Foot Valves. Actual and Budget operating data by product for the most recent reporting period are as follows: Thank you, appreciate your helparrow_forwardLearn Co Learn Co manufactures and sells one product, an abacus for classroom use, with two models, the Basic model and the Deluxe model. The company began operations on January 1, 20Y1, and is planning for 20Y2, its second year of operations, by preparing budgets from its master budget. The company is trying to decide how many units to manufacture, how much it might spend on direct materials and direct labor, and what their factory overhead expenses might be. In addition, the company is interested in budgeting for selling and administrative costs, and in creating a budgeted income statement showing a prediction of net income for 20Y2. You have been asked to assist the controller of LearnCo in preparing the 20Y2 budgets. Sales Budget The sales budget often uses the prior year's sales as starting point, and then sales quantities are revised for various factors such as planned advertising and promotion, projected pricing changes, and expected industry and general economic conditions.…arrow_forwardPlease show your work.arrow_forward
- Provide answerarrow_forwardUsing the single-rate method, allocate gift-wrapping costs to different departments in the following way: Q. Calculate the budgeted rate based on the budgeted number of gifts to be wrapped and allocate costs based on actual usage.arrow_forwardBruer Jeep Tours operates Jeep tours in the heart of the Colorado Rockies. The company bases its budgets on two measures of activity (I.e., cost drivers), namely guests and Jeeps. One vehicle used in one tour on one day counts as a jeep. Each Jeep has one tour guide. The company uses the following data in its budgeting: Guests Jeeps Revenue Expenses: Fixed element per month Revenue $0 Tour guide wages Vehicle expenses $ 6,000 Administrative expenses $ 3,100 In November, the company budgeted for 370 guests and 165 Jeeps. The actual activity for the month was 384 guests and 150 Jeeps. Tour guide wages Vehicle expenses Administrative expenses Total expense Net operating income Variable element per guest $183 Required: Prepare a report showing the company's activity variances for November. Label each varlance as favorable (F) or unfavorable (U). (Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (l.e., zero varlance). Input…arrow_forward
- Assume University Athletic Oriole Club sells T-shirts for $22 and anticipates selling 5,500 shirts during football season. The club purchases the shirts from a local dealer for $17.00. Budgeted foxed costs of $23,000 are made up of $2.500 of selling expense and the remainder is $16.500 administrative expense. The selling expenses include a sales commission of $0.10 per shirt. All other selling costs are fixed. Prepare an income statement in the contribution margin format. University Athletic Oriole Club Income Statementarrow_forwardQ.Prepare a direct labor budget in both hours and dollars.arrow_forwardPLEASE ANSWER WITH A STEP BY STEP SOLUTIONarrow_forward
- Using the single-rate method, allocate gift-wrapping costs to different departments in the following way: Q.Calculate the budgeted rate based on the practical gift-wrapping capacity available and allocate costs based on actual usage.arrow_forwardA. Determine CTC’s budgeted net income for 20x2. B. Assuming the sales mix remains as budgeted, determine how many units of each product CTC must sell in order to break even in 20x2arrow_forwardIndicate which of the following descriptions is most likely to describe each cost listed below.Description CostsEngineered cost Cost of ingredients in a breakfast cereal Committed cost Cost of advertising for a credit card company Discretionary cost Depreciation on an insurance company’s computer Cost of charitable donations that are budgeted as 1 percent of sales revenue Research and development costs, which have been budgeted at $45,000 per yeararrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning