Question
FIND SALES BUDGET, PRODUCTION BUDGET, DIRECT MATERIAL AND LABOR BUDGETS, SELLING AND ADMIN, AND CASH BUDGET: JANUARY FEBRUARY MARCH TOTAL BUDGETED SALES (UNITS) 1000 2,000
FIND SALES BUDGET, PRODUCTION BUDGET, DIRECT MATERIAL AND LABOR BUDGETS, SELLING AND ADMIN, AND CASH BUDGET:
JANUARY | FEBRUARY | MARCH | TOTAL | |
BUDGETED SALES (UNITS) | 1000 | 2,000 | 6,000 | 9 ,000.00 |
1. THE PRICE FOR EACH UNIT IS $2.00 2. FROM PAST EXPERIENCE, MANAGEMENT WANTS ENDING INVENTORY TO EQUAL 10% OF THE FOLLOWING MONTH'S SALES 3. DECEMBER'S ENDING INVENTORY WAS 500 UNITS 4. MARCH'S ENDING INVENTORY NEEDS TO BE 600 UNITS 5. EACH UNIT NEEDS 10 GRAMS OF DIRECT MATERIAL, COSTING $.05/GRAM 6. DECEMBER'S ENDING DIRECT MATERIAL INVENTORY WAS 200 UNITS, COSTING $10 7. MANAGEMENT WANTS MARCH'S DIRECT MATERIAL ENDING INVENTORY TO BE 1000 UNITS, COSTING $50 8. FROM PAST EXPERIENCE, MANAGEMENT WANTS ENDING DIRECT MATERIALS TO EQUAL 15% OF NEXT MONTH'S PRODUCTION NEEDS 9. IT TAKES 1 LABORER 10 MINUTES TO MAKE 1 UNIT OF PRODUCT. LABORERS ARE PAID $5/HOUR 10. SELLING AND ADMIN HAS BOTH FIXED AND VARIABLE COMPONENTS. THE FIXED EXPENSES ARE AT $500/MONTH WITH $100 BEING FOR DEPRECIATION. THE VARIABLE EXPENSE IS $.02 /UNIT 11. ALL SALES ARE ON ACCOUNT (CUSTOMERS TAKE INVENTORY AND PAY FOR IT LATER) 70% OF ALL SALES ARE COLLECTED IN THE MONTH OF THE SALE. 25% IS COLLECTED IN THE SUBSEQUENT MONTH. 5% IS UNCOLLECTABLE $3,000 OF DECEMBER'S SALES WILL BE COLLECTED IN JANUARY 12. BORROWING IS DONE AT THE BEGINNING OF THE MONTH AND REPAYMENTS ARE MADE AT THE END OF THE MONTH. THE COMPANY CAN BORROW AT A RATE OF 12%/YEAR AND THE COMPANY REQUIRES A MINIMUM CASH BALANCE OF $1,000. BORROWING IS DONE IN $1,000 INCREMENTS 13. 1 JANUARY OPENING CASH BALANCE IS $1,500 14. $2,000 WAS BORROWED ON 1 DECEMBER
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started