Concept explainers
Preparing an operating budget—sales, production, direct materials, direct labor, overhead, COGS, and S&A expense budgets
Learning Objective 3
3. POHR $10
4. Adult bats COGS $72,540
The Langley Batting Company manufactures wood baseball bats. Langley’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. Langley sells the bats to sporting goods stores, and all sales are on account. The youth bat sells for $40; the adult bat sells for $65. Langley’s highest sales volume is in the first three months of the year as retailers prepare for the spring baseball season. Langley’s balance sheet for December 31, 2018, follows:
LANGLEY BATTING COMPANY Balance SheetDecember 31, 2018 |
||
Assets | ||
Current Assets: | ||
Cash | $30,000 | |
16,700 | ||
Raw Materials Inventory | 6,000 | |
Finished Goods Inventory | 21,300 | |
Total Current Assets | $74,000 | |
Property, Plant, and Equipment: | ||
Equipment | 130,000 | |
Less: Accumulated |
(50,000) | 80,000 |
Total Assets | $154,000 | |
Liabilities | ||
Current Liabilities: | ||
Accounts Payable | $15,200 | |
Common Stock, no par | $90,000 | |
48,800 | ||
Total Stockholders’ Equity | 138,800 | |
Total Liabilities and Stockholders’ Equity | $154,000 |
Other data for Langley Batting Company for the first quarter of 2019:
a. Budgeted sales are 1,200 youth bats and 2,600 adult bats.
b. Finished Goods Inventory on December 31, 2018, consists of 300 youth bats at $14 each and 950 adult bats at $18 each.
c. Desired ending Finished Goods inventory is 350 youth bats and 300 adult bats; FIFO inventory costing method is used
d. Direct materials requirements are 48 ounces of wood per youth bat and 56 ounces of wood per adult bat. The cost of wood is $0.25 per ounce.
e. Raw Materials Inventory of December31, 2018, consists of 24,000 ounces of wood at $0.25 per ounce.
f. Desired ending Raw Materials Inventory is 24,000 ounces (indirect materials are insignificant and not considered for budgeting purposes).
g. Each bat requires 0.7 hours of direct labor; direct labor costs average $18 per hour.
h. Variable manufacturing overhead is $0.30 per bat.
i. Fixed manufacturing overhead includes $1,300 per quarter in depreciation and $20,140 per quarter for other costs, such as insurance and property taxes.
j. Fixed selling and administrative expenses include $9,000 per quarter for salaries; $2,500 per quarter for rent; $1,000 per quarter for insurance; and $200 per quarter for depreciation.
k. Variable selling and administrative expenses include supplies at 2% of sales.
Requirements
1. Prepare Langley’s sales budget for the first quarter of 2019.
2. Prepare Langley’s production budget for the first quarter of 2019.
3. Prepare Langley’s direct materials budget, 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 Langley’s cost of goods sold budget for the first quarter of 2019.
5, Prepare Langley’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 Accounting: The Managerial Chapters, Student Value Edition (12th Edition)
- (Learning Objective 5: Use the COGS model to make management decisions)Spicer Industries prepares budgets to help manage the company. Spicer is budgeting forthe fiscal year ended January 31, 2018. During the preceding year ended January 31, 2017,sales totaled $9,700 million and cost of goods sold was $6,400 million. At January 31, 2017,inventory was $1,500 million. During the upcoming 2018 year, suppose Spicer expects costof goods sold to increase by 12%. The company budgets next year’s ending inventory at$1,800 million.Requirement1. One of the most important decisions a manager makes is how much inventory to buy. Howmuch inventory should Spicer purchase during the upcoming year to reach its budget?arrow_forward(J) Citations are required for this exercise. Comments to other students must be detailed and substantive. Alpaca Industries, located in the beauty pacific Northwest, manufactures a household electronic device. The company is fairly small with revenues and total assets of approximately $370,000 and $300,000, respectively. The company has never maintained a budget since its inception, and as a new hire, you are eager to create a budget for the company. Write a 1-page memo, explaining to the owner the advantages of budgeting. In your memo, provide exact page number citations. Please note that any responses without citations will not be graded. Only the original responses are graded; subsequent edits are not graded.arrow_forward1. Question Content Area Sales Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and high school. FlashKick’s best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, FlashKick expects to sell the following: Practice Balls Match Balls Units Selling Price Units Selling Price January 50,000 $8.25 7,000 $16.00 February 58,000 $8.25 8,000 $16.00 March 80,000 $8.25 13,000 $16.00 April 100,000 $8.25 18,000 $16.00 Required: Question Content Area 1. Construct a sales budget for FlashKick for the first three months of the coming year. Show total sales for each product line by month and in total for the first quarter. If required, round your answers to the nearest cent. FlashKick CompanySales BudgetFor the First Quarter of Next Year…arrow_forward
- LearnCo LearnCo 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 a 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_forward2. Direct Labor Budget for Service The School of Accounting (SOA) at State University is planning its annual fundraising campaign for accounting alumni. This year, the SOA is planning a call-a-thon and will ask Beta Alpha Psi members to volunteer to make phone calls to a list of 7,000 alumni. The Dean's office has agreed to let Beta Alpha Psi use their offices from 6 p.m. to 9 p.m. each weekday so that they will have access to phones. Each volunteer will be provided with a phone and a script with an introduction and suggested responses to various questions that had been asked in the past. Carol Johnson, Beta Alpha Psi faculty advisor, estimates the following: Of the 7,000 phone numbers, roughly 10 percent will be wrong numbers (because alumni change addresses and phone numbers without updating State University). In that case, the student is instructed to apologize to the answering party, hang up, and move on to the next phone number. Each of these calls takes about three minutes.…arrow_forwardDirect Materials Purchases Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and high school. FlashKick’s best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, FlashKick expects to sell the following: Practice Balls Match Balls Units Selling Price Units Selling Price January 48,000 $8.75 6,100 $16.50 February 62,000 $8.75 7,800 $16.50 March 87,000 $8.75 13,000 $16.50 April 100,000 $8.75 16,000 $16.50 FlashKick requires ending inventory of product to equal 20 percent of the next month’s unit sales. Beginning inventory in January was 9,600 practice soccer balls and 1,220 match soccer balls. Every practice ball requires 0.6 square yard of polyvinyl chloride panels, one bladder with valve (to fill with air), and 3 ounces of glue. FlashKick’s…arrow_forward
- profile-image Student question Time to preview question: 00 : 08 : 51 The Epsilon Co. have a building, which houses three production department, Alpha, Beta and Gamma, and one service department Delta. The service department, Delta is wholly involved in working for the three production departments and it is estimated that department Alpa uses 50%, department Beta uses 30% and department Gamma uses 20% of the services of department Delta. The budgeted overhead for the four departments for a period were: REQUIRED: a. Apportion the costs to the departments on the most equitable bases and calculate the overhead absorption rate, based on labour hours, for all the production department.arrow_forwardDirect Materials Purchases Budget Smart Strike Company manufactures and sells soccer balls for teams of children in elementary and high school. Smart Strike's best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, Smart Strike expects to sell the following: Practice Balls Match Balls Units Selling Price Units Selling Price January 48,000 $8.85 6,400 $17.20 February 58,000 $8.85 7,500 $17.20 March 86,000 $8.85 13,000 $17.20 April 105,000 $8.85 17,000 $17.20 Smart Strike requires ending inventory of product to equal 20 percent of the next month's unit sales. Beginning inventory in January was 9,600 practice soccer balls and 1,280 match soccer balls. Every practice ball requires 0.7 square yard of polyvinyl chloride panels, one bladder with valve (to fill with air), and 2 ounces of glue.…arrow_forwardManagement Accounting Course Project – Part 1, B Group The Terranova Company is preparing information to complete its master budget for the quarter ending December 31, 2020. The company intends to make unit sales in the related months as follows: September 5,000 October 9,750 November 11,700 December 14,625 Units are to be sold for $10 each. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following the sale. *Required: 1) Prepare a sales budget for Terranova for the quarter ending December 31, 2020. Show activity by month and in total. (Hint: a quarter = 3 months.) 2) Complete a schedule of expected cash collections for the quarter ending December 31, 2020. Show activity by month and in total.arrow_forward
- Personal Protective Gears & More (PPGM) design and manufacture masks for students. Afterproduction, the masks are placed into individual cases, before being transferred into Finished Goods. Theaccounting records of the business reflect the following data at June 30, 2021, for the manufacturing ofmasks for Mount Marlie High School.Inventory 1/7/2020 30/6/2021Raw Materials $230,000 $260,000Factory Supplies $35,000 $24,000Work in Progress $348,300 $203,300Finished Goods $632,900 $485,000Other information:Sales Revenue $5,731,000Factory Supplies Purchased 64,000Direct Factory Labor 792,000Raw Materials Purchased 560,000Plant janitorial service 37,000Depreciation: Plant & Equipment 186,000Total Utilities 1 481,250Production Supervisor’s Salary 450,000Design Costs (School Logo) 26,000Packaging Cases Cost 42,000Total Insurance 2 168,000Delivery Vehicle Drivers’ Wages 181,500Depreciation: Delivery Vehicle 53,290Property Taxes 3 240,000Administrative Wages & Salaries…arrow_forwardPersonal Protective Gears & More (PPGM) design and manufacture masks for students. Afterproduction, the masks are placed into individual cases, before being transferred into Finished Goods. Theaccounting records of the business reflect the following data at June 30, 2021, for the manufacturing ofmasks for Mount Marlie High School.Inventory 1/7/2020 30/6/2021Raw Materials $230,000 $260,000Factory Supplies $35,000 $24,000Work in Progress $348,300 $203,300Finished Goods $632,900 $485,000Other information:Sales Revenue $5,731,000Factory Supplies Purchased 64,000Direct Factory Labor 792,000Raw Materials Purchased 560,000Plant janitorial service 37,000Depreciation: Plant & Equipment 186,000Total Utilities 1 481,250Production Supervisor’s Salary 450,000Design Costs (School Logo) 26,000Packaging Cases Cost 42,000Total Insurance 2 168,000Delivery Vehicle Drivers’ Wages 181,500Depreciation: Delivery Vehicle 53,290Property Taxes 3 240,000Administrative Wages & Salaries…arrow_forwardPersonal Protective Gears & More (PPGM) design and manufacture masks for students. Afterproduction, the masks are placed into individual cases, before being transferred into Finished Goods. Theaccounting records of the business reflect the following data at June 30, 2021, for the manufacturing ofmasks for Mount Marlie High School.Inventory 1/7/2020 30/6/2021Raw Materials $230,000 $260,000Factory Supplies $35,000 $24,000Work in Progress $348,300 $203,300Finished Goods $632,900 $485,000Other information:Sales Revenue $5,731,000Factory Supplies Purchased 64,000Direct Factory Labor 792,000Raw Materials Purchased 560,000Plant janitorial service 37,000Depreciation: Plant & Equipment 186,000Total Utilities 1 481,250Production Supervisor’s Salary 450,000Design Costs (School Logo) 26,000Packaging Cases Cost 42,000Total Insurance 2 168,000Delivery Vehicle Drivers’ Wages 181,500Depreciation: Delivery Vehicle 53,290Property Taxes 3 240,000Administrative Wages & Salaries…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education