BUILT RIGHT FURNITURE MANUFACTURES DESES, CHAIRS, TABLES & SHELF UNITS SOLD TO SCHOOLS ON THE EAST COAST. THE CONTROLLER OF THE COMPANY IS CURRENTLY PREPARING A BUDGET FOR THE THIRD QUARTER OF THE YEAR. THE FOLLOWING SALES FORCAST HAS BEEN MADE BY THE DESK DIVISION'S SALES MANAGER JULY 10,000 DESK & CHAIR SETS AUGUST 12.000 DESK & CHAIR SETS Aug SEPTEMBER 15,000 DESK & CHAIR SETS EACH DESK & CLAIR SET REQUIRES 10 BOARD FEET OF MAPLE PLANKS AND 1.5 HOURS OF DIRECT LABOR. EACH SET SELLS FOR $SO, MAPLE PLANKS COST $ SO PER BOARD FOOT, AND THE COMPANY ENDS EACH MONTH WITH ENOUGH WOOD TO COVER 10% OF THE NEXT MONTH'S PRODUCTION REQUIREMENTS. THE COMPANY INCURS A COST OF $20 PER HOUR FOR DIRECT LABOR WAGES. THE COMPANY ENDS EACH MONTH WITH ENOUGH FINISHED GOODS INVENTORY TO COVER 20% OF THE NEXT MONTHS SALES, REQUIRED: COMPLETE THE FOLLOWING BUDGET SCHEDULES, 1. SALES BUDGET July sept SALES (IN SETS) 10,000 SALES PRICE PER SET X $50 SALES REVENUE $500,000 2. PRODUCTION BUDGET (IN SETS) SALES 10,000 ADD: DESIRED ENDING INV. 2.400 3,000 TOTAL REQUIREMENTS 12,400 LESS: PROJECTED BEGIN INV. 2.000 PLANNED PRODUCTION 10,400 3. RAW-MATERIAL PURCHASES PLANNED PRODUCTION (SETS) 10,400 RM REQUIRED PER SET (BOARD FT) X 10 RM REQUIRED FOR PROD (BF) 104,000 ADD: DESIRED END INV. OF RM IN BRD FT (10% OF NEXT MO) 12,600 16,000 TOTAL REQUIREMENTS 116,600 LESS: PROJECTED BEG INV. 10% 10.400 PLAN PUR OF RM (BRD FT).... 106,200 COST PER BOARD FOOT X $50 PLAN PUR OF RM (DOLLARS) $53,100 4. DIRECT-LABOR BUDGET PLANNED PRODUCTION (SETS) 10,400 OL HOURS PER SET X 15 DL HOURS REQUIRED. 15,600 COST PER HOUR. X 520 PLANNED DL COST $312,000 Attached are two shedts. One sheet is a cash budget. The second sheet is a partial Master Budget - including a sales budget, a production budget, a DM budget and a DL budget. (cost per board foot for lumber should be $ 0.50) (I'm sorry but July, August, September aren't lined up correctly - the right column 3,000 and 16,000 should be the next month - October) On a separate sheet if necessary complete these budgets and upload them to the assignment module of this Kodiak Classroom by 8:00 am Friday 4/16/21