Question

Part A.

Wally's widgets is starting operations as of January 1. The company sells a single product and expects first month's sales to be 10,000 units with sales increasing by 250 units per month thereafter. the sales price for the product is $12.00.

The company has a 50% gross margin on its products and pays a 10% commission on sales

-What is the budget assumption for First month's sales in Units, Sales Growth per month, Sales price per unit, Gross margin, commission.

Part B. Wally's Widgets expects the ending inventory balance at the end of any month to be 60% of the expected sales for the following month. The company wishes to maintain a minimum cash balance of $20,000 at all times.

The company has access to a line of credit that incurs an interest rate of 12% per year.

-What is the budget assumption for Ending inventory, Minimum Cash Balance, and Interest rate.

Answer 1

PART A

sale 10000*12 120000 a) budget assumption unit =10000

-cost of good sold 80000 b) sales growth per month =25

(120000*100/150) c)sales price=12

;gross margin 40000 d) gross margin= 40000

- commission e)commission =12000

10% of sale 12000

net margin 28000

PARTB) January ending inventory

a) budget assumption for ending inventory = 60% of february sale

=60%*10250

=6150 unit

minimum cash balance= 20000

interest rate = 12%

per month =12/12

=1%