Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

BUILT RIGHT FURNITURE MANUFACTURES DESES, CHAIRS, TABLES & SHELF UNITS SOLD TO SCHOOLS ON THE EAST COAST. THE CONTROLLER OF THE COMPANY IS CURRENTLY PREPARING

image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions