Scholastic Furniture, Incorporated, manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company's Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division's sales manager. April May June 14,500 desk-and-chair sets 16,500 desk-and-chair sets 19,500 desk-and-chair sets Each desk-and-chair set requires 12 board feet of pine planks and 1.3 hours of direct labor. Each set sells for $45. Pine planks cost $.50 per board foot, and the division ends each month with enough wood to cover 10 percent of the next month's production requirements. The division incurs a cost of $25 per hour for direct-labor wages and fringe benefits. The division ends each month with enough finished-goods inventory to cover 20 percent of the next month's sales. Required: Complete the following budget schedules. 1. Sales budget. 2. Production budget (in sets). 3. Raw-material purchases.

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter11: Linear Optimization Models
Section: Chapter Questions
Problem 13P: The Silver Star Bicycle Company will manufacture both mens and womens models for its Easy-Pedal...
icon
Related questions
Question
s
Scholastic Furniture, Incorporated, manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school
systems throughout the Midwest. The controller of the company's Desk Division is currently preparing a budget for the second quarter
of the year. The following sales forecast has been made by the division's sales manager.
April
May
June
14,500 desk-and-chair sets
16,500 desk-and-chair sets
19,500 desk-and-chair sets
Each desk-and-chair set requires 12 board feet of pine planks and 1.3 hours of direct labor. Each set sells for $45. Pine planks cost $.50
per board foot, and the division ends each month with enough wood to cover 10 percent of the next month's production requirements.
The division incurs a cost of $25 per hour for direct-labor wages and fringe benefits. The division ends each month with enough
finished-goods inventory to cover 20 percent of the next month's sales.
Required:
Complete the following budget schedules.
1. Sales budget.
2. Production budget (in sets).
3. Raw-material purchases.
4. Direct-labor budget.
Complete this question by entering your answers in the tabs below.
Required 1 Required 2 Required 3
Sales budget:
Required 4
April
May
June
Sales (in sets)
Sales price per set
$
14,500
45
Sales revenue
$
652,500 $
0 $
0
<
Required 1
Required 2 >
Transcribed Image Text:s Scholastic Furniture, Incorporated, manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company's Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division's sales manager. April May June 14,500 desk-and-chair sets 16,500 desk-and-chair sets 19,500 desk-and-chair sets Each desk-and-chair set requires 12 board feet of pine planks and 1.3 hours of direct labor. Each set sells for $45. Pine planks cost $.50 per board foot, and the division ends each month with enough wood to cover 10 percent of the next month's production requirements. The division incurs a cost of $25 per hour for direct-labor wages and fringe benefits. The division ends each month with enough finished-goods inventory to cover 20 percent of the next month's sales. Required: Complete the following budget schedules. 1. Sales budget. 2. Production budget (in sets). 3. Raw-material purchases. 4. Direct-labor budget. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Sales budget: Required 4 April May June Sales (in sets) Sales price per set $ 14,500 45 Sales revenue $ 652,500 $ 0 $ 0 < Required 1 Required 2 >
Expert Solution
steps

Step by step

Solved in 5 steps

Blurred answer
Knowledge Booster
Decision to Sell before or after additional processing
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,