Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SALES PROJECTIONS Wilson Sports basketball sales in August were 152,000 units. Sales are expected to grow by 1.5% in September. October sales are expected to

image text in transcribed
image text in transcribed
SALES PROJECTIONS Wilson Sports basketball sales in August were 152,000 units. Sales are expected to grow by 1.5\% in September. October sales are expected to be 1,000 units less than in September. November sales will be 1% more than October. The selling price of the basketballs will remain the same $30 per unit. December sales projection is 157,000 units. INVENTORY POLICIES FINISHED GOODS MAINTAIN AND ENDING INVENTORY EQUAL. TO 25\% OF NEXT MONTH SALES ACTUAL BEGINNING INVENTORY 38,500 UNITS DIRECT MATERIALS MAINTAIN AND ENDING INVENTORY EQUAL. TO 30\% OF NEXT MONTH PRODUCTION ACTUAL. BEGINNING INVENTORY 9,000 POUNDS The cost of materials purchased in August were $210,000 REQUIREMENTS Each basketball requires 25 pounds of materials at a cost of $7 per pound. December production are projected to be 156,000 units: Each basketball requires 15 minutes of labor at a rate of $12.00 per hour Fixed Overhead is $400,000 monthly and variable overhead is assigned as 130% of direct labor SELLING AND ADMINISTRATIVE EXPENSES Commissions are 10% of Sales and Sales salaries are $90,000 monthly General 8 Administrative Expenses are $150,000 monthly OTHER EXPENSES AND CASH FLOWS A new machine at a total cost of $2,500,000 will be purchase in September Cash dividends of $2 million will be paid in November Last quarter taxes of $2,200,000 will be paid in October, because taxes are paid in next quarter at tax rate of 35% Fixed Overhead is $400,000 monthly and variable overhead is assigned as 130% of direct labor SELLING AND ADMINISTRATIVE EXPENSES Commissions are 10% of Sales and Sales salaries are $90,000 monthly General \& Administrative Expenses are $150,000 monthly OTHER EXPENSES AND CASH FLOWS A new machine at a total cost of $2,500,000 will be purchase in September Cash dividends of $2 million will be paid in November Last quarter taxes of $2,200,000 will be paid in October, because taxes are paid in next quarter at tax rate of 35% CASH POLICY The firm requires an ending cash balance of $360,000. Actual cash balance is $360,000 The firm has a short credit arrangement (credit line) with The National Bank. If the cash balance is lower than the required ending balance, the firm borrows from the bank. If the cash balance is higher than the required ending balance, the firm will pay the loan to the bank. The outstanding loan balance is $1,000,000 and the bank charges a 1% monthly interest rate. 80% of sales are cash sales and the remaining 20% collected one month later. 90% of direct materials purchased are paid in cash and the remaining 10% are paid in the next month. CALCULATE TOTAL CASH PAYMENTS FOR NOVEMBER ROUND YOUR ANSWER TO ZERO DECIMAL PLACES DON'T USE COMMA SEPARATORS

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_2

Step: 3

blur-text-image_3

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

Financial Analysis With Microsoft Excel

Authors: Timothy R. Mayes

9th Edition

0357442059, 9780357442050

More Books

Students also viewed these Finance questions