Activity No. 12 Master Budget ComputationFurniture Manufacturing Company - School Desk DivisionScholastic Furniture Inc. Manufactures a variety of desks, chairs, tables, and shelf units that aresold to public school systems throughout the Philippines. The controller of the company's DeskDivision is currently preparing a budget for the thrid quarter of the year. The following forecasthas been made by the division's sales manager.Sales Budget - Sales Price = P600/setAugustP60,000JulySeptemberOctoberP54,000P75,000P90,000Based on the information below, prepare the company's third quarter budget of the following:A. SalesB. Production.• Desired ending inventory (finished sets) is equal to 20% of next month's budgeted salesC. Raw Material Purchases• 10 board feet per set• Desired ending inventory (board feet) = 10% of next month's use of board feet• Cost of raw material purchases = P6.00/board footD. Direct Labor BudgetDirect labor hours per set = 1.5Direct labor cost per hour - P210.00

Name: Activity No. 12 Master Budget ComputationFurniture Manufacturing Comp
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: Activity No. 12 Master Budget ComputationFurniture Manufacturing Company - School Desk DivisionScholastic Furniture Inc. Manufactures a variety of desks, chairs, tables, and shelf units that aresold to public school systems throughout the Philippine

Budgeting is an Estimation of Expected Expenses or a particular production to be need in Future.…

Business

Accounting

Activity No. 12 Master Budget Computation Furniture Manufacturing Company - School Desk Division Scholastic Furniture Inc. Manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Philippines. The controller of the company's Desk Division is currently preparing a budget for the thrid quarter of the year. The following forecast has been made by the division's sales manager. Sales Budget - Sales Price = P600/set July August September October P54,000 P60,000 P75,000 P90,000 Based on the information below, prepare the company's third quarter budget of the following: A. Sales B. Production. • Desired ending inventory (finished sets) is equal to 20% of next month's budgeted sales C. Raw Material Purchases • 10 board feet per set • Desired ending inventory (board feet) = 10% of next month's use of board feet • Cost of raw material purchases = P6.00/board foot D. Direct Labor Budget • Direct labor hours per set = 1.5 • Direct labor cost per hour - P210.00

Activity No. 12 Master Budget Computation Furniture Manufacturing Company - School Desk Division Scholastic Furniture Inc. Manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Philippines. The controller of the company's Desk Division is currently preparing a budget for the thrid quarter of the year. The following forecast has been made by the division's sales manager. Sales Budget - Sales Price = P600/set July August September October P54,000 P60,000 P75,000 P90,000 Based on the information below, prepare the company's third quarter budget of the following: A. Sales B. Production. • Desired ending inventory (finished sets) is equal to 20% of next month's budgeted sales C. Raw Material Purchases • 10 board feet per set • Desired ending inventory (board feet) = 10% of next month's use of board feet • Cost of raw material purchases = P6.00/board foot D. Direct Labor Budget • Direct labor hours per set = 1.5 • Direct labor cost per hour - P210.00

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

PR 9-37 (Algo) Completion of Budget Schedules (LO 9-3, 9-5, 9-6) 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 13,000 desk-and-chair sets 15,000 desk-and-chair sets 18,000 desk-and-chair sets Each desk-and-chair set requires 12 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 $22 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:…
Flexible budget for Assembly Department Steelcase Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it assembles filing cabinets in an Assembly Department.Assume the following information for the Assembly Department: Direct labor per filing cabinet 12 minutesSupervisor salaries $150,000 per monthDepreciation $24,500 per monthDirect labor rate $22 per hour Direct labor per filing cabinet 12 minutes Supervisor salaries $150,000 per month Depreciation $24,500 per month Direct labor rate $22 per hour Prepare a flexible budget for 18,000, 20,000, and 22,000 filing cabinets for the month ofAugust in the Assembly Department, similar to Exhibit 5
es 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 11,000 desk-and-chair sets 13,000 desk-and-chair sets 16,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 $52. Pine planks cost $.60 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 $23 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.…
Complete d through g please and thank you
Complete part a and b please and thank you
Only typed solution
Question 8.1 Sun Company manufacturers beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 30,000 August 70,000 September 50,000 October 20,000 November 10,000 December 10,000 The selling price of the umbrellas is $12 each. All sales are on account. Based on past experience, sales are expected to be collected in the following pattern: 30% In the month of sale 65% In the month following sale 5% uncollectable Sales for June were $300,000 The company maintains finished goods inventories equal to 15% of the following month’s sales. This requirement will be met at the end of June. Each beach umbrella…
3. Question Content Area Cash Budget Khloe Company imports gift items from overseas and sells them to gift shops and department stores throughout the United States. Khloe Company provided the following information: The October 31 balance in the cash account is $54,115. All sales are on account. Sales in September were $980,000 and in October were $1,260,000. November sales are expected to be $2,175,000. In Khloe’s experience, 70 percent of sales are collected in the month of sale and 26 percent are collected in the month following sale. The remaining credit sales are uncollectible. Khloe purchases all merchandise on account. Purchases in September were $730,000 and in October were $950,000. November purchases are expected to be $2,030,000 as Khloe prepares for the Christmas buying season. Fifteen percent of purchases are paid in the month of purchase, while the remainder is paid in the month following the purchase month. Khloe Company has nine employees who are paid a total of…
A-2
Please make the production budget in units and materials purchases budget
Question 3
国 Requlred Informatlon (The following information applies to the questions displayed below.] Morganton Company makes one product and it provided the following information to help prepare the master budget a. The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and September are 8,300. 14,000, 16,000, and 17,000 units, respectively. All sales are on credit. b. Forty percent of credit sales are collected in the month of the sale and 60% in the following month. c. The ending finished goods inventory equals 25% of the following month's unit sales. d. The ending raw materials inventory equals 10% of the following month's raw materials production needs. Each unit of finished goods requires 5 pounds of raw materials. The raw materials cost $2.00 per pound. e. Forty percent of raw materials purchases are paid for in the month of purchase and 60% in the following month. f. The direct labor wage rate is $15 per hour. Each unit of finished goods requires two…