Question

In: Accounting

Scholastic Furniture, Inc. manufactures a variety of desks, chairs, tables, and shelf units that are sold...

Scholastic Furniture, Inc. 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 10,000 desk-and-chair sets
May 12,000 desk-and-chair sets
June 15,000 desk-and-chair sets

Each desk-and-chair set requires 10 board feet of pine planks and 1.5 hours of direct labor. Each set sells for $50. 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 $20 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.

Solutions

Expert Solution

Note : In the absence of data for the budgeted sales of the month of july ,we have assumed it to be same as that of june .

Can you please rate the answer

THANKS!!!!!


Related Solutions

Scholastic Furniture, Inc., manufactures a variety of desks, chairs, tables, and shelf units that are sold...
Scholastic Furniture, Inc., 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 10,000 desk-and-chair sets May 12,000 desk-and-chair sets June 15,000 desk-and-chair sets Each desk-and-chair set requires 10 board feet of pine planks and 1.5 hours of...
Scholastic Furniture, Inc. manufactures a variety of desks, chairs, tables, and shelf units that are sold...
Scholastic Furniture, Inc. 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 10,000 desk-and-chair sets May 12,000 desk-and-chair sets June 15,000 desk-and-chair sets Each desk-and-chair set requires 10 board feet of pine planks and 1.5 hours of...
School Days Furniture, Inc., manufactures a variety of desks, chairs, tables, and shelf units which are...
School Days Furniture, Inc., manufactures a variety of desks, chairs, tables, and shelf units which are sold to public school systems throughout the midwest. The controller of the company’s Desk Division is currently preparing a budget for the third quarter of the year. The following sales forecast has been made by the division’s sales manager.      July 5,000 desk-and-chair sets   August 6,000 desk-and-chair sets   September 7,500 desk-and-chair sets Each desk-and-chair set requires 10 board feet of pine planks and 1.5...
Discount Furniture Pty Ltd manufactures a variety of desks, chairs, tables and shelf units which are...
Discount Furniture Pty Ltd manufactures a variety of desks, chairs, tables and shelf units which are sold to public school systems throughout Queensland. The accountant of the company’s School Desk Division is currently preparing a budget for the first quarter of 2018. The following sales forecast has been made by the division's sales manager.           January 
   5,000 desk and chair sets           February 
   6,000 desk and chair sets           March 
   7,500 desk and chair...
SquerDeal Mfg manufactures tables and desks, which are sold in sets of 4 chairs to tables...
SquerDeal Mfg manufactures tables and desks, which are sold in sets of 4 chairs to tables to bussiness, school, and public facilities. They reported the fallowing financial information for last year: Direct Labor 20,000hrs @$15/hr, production Manager Salary $80,000, Factory Rent $60,000, Equipment Maintenance$5,000(considered a variable expense), Equipment Depreciation $25,000, Production for the year 35,000 units, Total Revenue $12,000,000, Total table and chairs set sold during the period 30,000, Operating Income under absorption costing (after non-production expenses) $5,000,000 what would...
Steelcase Production Steelcase Corporation manufactures 3 basic products: chairs, desks, and tables. Below is chart which...
Steelcase Production Steelcase Corporation manufactures 3 basic products: chairs, desks, and tables. Below is chart which summarizes the number of labor hours spent for each product in each division. Chairs Desks Tables Process Carpentry 2 3 6 Finishing 1 1 1 Assembly 4 6 2 In a given week, Steelcase has 250 hours available for carpentry, 100 hours available for finishing, and 400 hours available for assembly. Steelcase makes a profit of $66 on each chair, $75 on each desk,...
A division of the Winston Furniture Company manufactures dining tables and chairs. Each table requires 40...
A division of the Winston Furniture Company manufactures dining tables and chairs. Each table requires 40 board feet of wood and 3 labor-hours. Each chair requires 16 board feet of wood and 4 labor-hours. The profit for each table is $50, and the profit for each chair is $40. In a certain week, the company has 3200 board feet of wood available and 520 labor-hours available. How many tables and chairs should Winston manufacture to maximize its profit? (Let x...
A furniture store manufactures 2 products; tables (X) and chairs (Y): the production process for each...
A furniture store manufactures 2 products; tables (X) and chairs (Y): the production process for each require a certain number of labor hours in the carpentry department and a certain number of labor hours in the painting department. Each table takes 3 hours of carpentry work and 2 hours of painting work. Each chair requires 4 hours of carpentry and 1 hour of painting. During the current month, 2,400 hours of carpentry time and 1,000 hours of painting time are...
Problem 4 Frank’s Fine Furniture makes tables, desks, bookcases, and other office furniture. At the North...
Problem 4 Frank’s Fine Furniture makes tables, desks, bookcases, and other office furniture. At the North California facility, they make tables. All parts of the table are purchased except for the tabletop that is fabricated at the plant. Tables are made to order for dealers who FAX orders into the sales department. Orders are processed from the order database on FIFO basis. The first step in the process is to cut the top ¾ pressboard. It takes one worker 20...
Party warehouse Inc. rents a wide variety of products (e.g. tables, chairs, tents and storage containers)...
Party warehouse Inc. rents a wide variety of products (e.g. tables, chairs, tents and storage containers) for special events. Upon rental, party warehouse requires a deposit which is forfeited if equipment is not returned at the end of the rental period. Deposit charged or twice the cost of the equipment, and party warehouse keeps equipment and it’s accounting records until deposits are forfeited. On April 5, a customer rented various containers for an event to be held on April 8,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT