Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Wilson Sports basketball sales in August were 152,000 units. Sales are expected to grow by 1.5% in September. Octobe sales are expected to be 1,000

image text in transcribed
image text in transcribed
Wilson Sports basketball sales in August were 152,000 units. Sales are expected to grow by 1.5% in September. Octobe 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 \& 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% 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% CASHPOLICY 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 botrows 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 nales 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 PRELIMINARY CASH BALANCE FOR SEPTEMBER 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 Modeling

Authors: Simon Benninga, Tal Mofkadi

5th Edition

0262046423, 9780253337825

More Books

Students also viewed these Finance questions

Question

=+c) How many baseballs produced were out of spec?

Answered: 1 week ago