Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Intermediate Accounting principles and analysis

Authors: Terry d. Warfield, jerry j. weygandt, Donald e. kieso

2nd Edition

471737933, 978-0471737933

More Books

Students also viewed these Accounting questions

Question

What influences peoples choice of values?

Answered: 1 week ago