- Submit your Excel File to Canvas (see docx.)
- Complete the Google Form answers (see screenshot)
EA
3.
LO 7.2
Navigator sells GPS trackers for $50 each. It expects sales of 5,000 units in quarter 1 and a 5% increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year.
EA
4.
LO 7.2
One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next month’s sales. Prepare a production budget for the first four months of the year.
EA
5.
LO 7.2
Sunrise Poles manufactures hiking poles and is planning on producing 4,000 units in March and 3,700 in April. Each pole requires a half pound of material, which costs $1.20 per pound. The company’s policy is to have enough material on hand to equal 10% of the next month’s production needs and to maintain a finished goods inventory equal to 25% of the next month’s production needs. What is the budgeted cost of purchases for March?
EA
6.
LO 7.2
Given the following information from Rowdy Enterprises’ direct materials budget, how much direct materials needs to be purchased?
EA
8.
LO 7.2
How many units are estimated to be sold if Skyline, Inc., has a planned production of 900,000 units, a desired beginning inventory of 160,000 units, and a desired ending inventory of 100,000 units?
EA
9.
LO 7.3
Cash collections for Wax On Candles found that 60% of sales were collected in the month of the sale, 30% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in January and February?
EA
12.
LO 7.3
Desiccate purchases direct materials each month. Its payment history shows that 70% is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment schedule for March if in January through March, it purchased $35,000, $37,000, and $39,000, respectively.
EA
15.
LO 7.4
Cold X, Inc. uses this information when preparing their flexible budget: direct materials of $2 per unit, direct labor of $3 per unit, and manufacturing overhead of $1 per unit. Fixed costs are $35,000. What would be the budgeted amounts for 20,000 and 25,000 units?
EA
17.
LO 7.5
The production cost for a waterproof phone case is $7 per unit and fixed costs are $23,000 per month. How much is the favorable or unfavorable variance if 5,500 units were produced for a total of $61,000?
