Echo Amplifiers prepared the following sales budget for the first quarter of 2018:
| Jan. | Feb. | Mar. | |
| Units | 900 | 1,200 | 1,600 |
| Sales price | $100 | $100 | $100 |
| Budgeted sales | $90,000 | $120,000 | $160,000 |
It also has this additional information related to its expenses:
| Direct material per unit | $1.50 |
| Direct labor per unit | 2 |
| Variable manufacturing overhead per hour | 0.50 |
| Fixed manufacturing overhead per month | 2,900 |
| Sales commissions per unit | 14 |
| Sales salaries per month | 4,900 |
| Delivery expense per unit | 0.50 |
| Factory utilities per month | 4,000 |
| Administrative salaries per month | 19,000 |
| Marketing expenses per month | 9,000 |
| Insurance expense per month | 10,000 |
| Depreciation expense per month | 9,000 |
Prepare a sales and administrative expense budget for each month in the quarter ending March 31, 2018. Enter all amounts as positive numbers.
| Echo Amplifiers | |||
| Sales and Administrative Budget | |||
| For the Quarter Ending March 31, 2018 | |||
| January | February | March | |
| Budgeted Sales in Units | |||
| Variable Expenses | |||
| ? | $ | $ | $ |
| ? | |||
| Total Variable Expenses | $ | $ | $ |
| Fixed Expenses | |||
| ? | $ | $ | $ |
| ? | |||
| ? | |||
| ? | |||
| ? | |||
| Total Fixed Expenses | $ | $ | $ |
| Total Selling and Administrative Expenses | $ | $ | $ |
Answer-
| ECHO AMPLIFIERS | |||
| SALES & ADMINISTRATIVE BUDGET | |||
| FOR THE QUARTER ENDING MARCH 31,2018 | |||
| PARTICULARS | JANUARY | FEBRUARY | MARCH |
| $ | $ | $ | |
| Budgeted sales in units | 900 | 1200 | 1600 |
| Variable expenses | |||
| Sales Commissions per unit | 900 units*$14 per unit=$12600 | 1200 units*$14 per unit=$16800 | 1600 units*$14 per unit=$22400 |
| Delivery expense per unit | 900 units*$0.50 per unit=$450 | 1200 units*$0.50 per unit=$600 | 1600 units*$0.50 per unit=$800 |
| Total variable expenses (a) | 13050 | 17400 | 23200 |
| Fixed Expenses | |||
| Sales salaries | 4900 | 4900 | 4900 |
| Administrative salaries | 19000 | 19000 | 19000 |
| Marketing expenses | 9000 | 9000 | 9000 |
| Insurance expense | 10000 | 10000 | 10000 |
| Depreciation expense | 9000 | 9000 | 9000 |
| Total fixed expenses (b) | 51900 | 51900 | 51900 |
| Total Selling & Administrative Expenses (c=a+b) | 64950 | 69300 | 75100 |
Echo Amplifiers prepared the following sales budget for the first quarter of 2018: Jan. Feb. Mar....
ang Company has provided the following budget information for the first quarter of 2018: Click the icon to view the budget information.) Additional data related to the first quarter of 2018 for Vang Company (Click the icon to view the data.) Read Х More Info Requirement 1. Prepare Vang Company's schedule of cash receipts from customers and schedule of cash payments for th Begin by preparing the schedule of cash receipts from customers for the first quarter of 2018 Cash...
SalesUnit sales for November 2019114,000Unit sales for December 2019103,000Expected unit sales for January 2020114,000Expected unit sales for February 2020111,000Expected unit sales for March 2020116,000Expected unit sales for April 2020125,000Expected unit sales for May 2020136,000Unit selling price$12Waterways likes to keep 10% of the next month’s unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale, and 15% of the Accounts Receivable are collected in the month after sale. Accounts...
b. estimated sales are:
Oct.
$131,976
Nov.
195,704
Dec.
249,267
Jan
124,288
Feb.
124,295
Mar.
124,358
What are the balances in accounts receivable for January,
February, and March if 65% of sales is collected in the month of
sale, 25% is collected the month after the sale, and 10% is second
month after the sale? Round your answers to two decimal
places.
Ending Balance
January
February
March
c. Cold X, Inc. uses the following information when preparing
their flexible budget:...
Sharpe Company has provided the following budget information for the first quarter of 2018: Total sales $218,000 Budgeted purchases of direct materials 40,300 Budgeted direct labor cost 37,000 Budgeted manufacturing overhead costs: Variable manufacturing overhead 1,125 Depreciation 1,100 Insurance and property taxes 6,750 Budgeted selling and administrative expenses: Salaries expense 12,000 Rent expense 4,500 Insurance expense 1,400 Depreciation expense 100 Supplies expense 10,900 Requirement 1. Prepare Sharpe Company's schedule of cash receipts from customers and schedule of cash payments for...
Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to deckers manufacturing s operation Current Assets as of December 31 (prior year): Cash 4600 Accounts receivable, net 47000 Inventory 15100 Property, plant, and equipment, net 123000 Accounts payable. 43000 Capital stock. 123500 Retained earnings. 23100 a. Actual sales in December were $71,000. Selling price per unit is projected to remain stable at $12 per unit throughout the budget period. Sales...
haney company has provided the following budget information
for the first quarter of 2018:
Haney Company has provided the following budget information for the first quarter of 2018 (Click the loon to view the budget information.) Additional data related to the first quarter of 2018 for Haney Company (Click the icon to view the data.) Read the requirements Requirement 1. Prepare Haney Company's schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2018...
Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalley Manufacturing's operations: (Click the icon to view the data.) (Click the icon to view additional data.) Read the requirements. Requirement 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. Dalley Manufacturing Cash Collections Budget For the Quarter Ended March 31 Month January February March Quarter Cash sales Credits sales Total...
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: January 40,000 February 50,000 March 60,000 April 60,000 May 62,000 The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: Finished goods inventory on January 1 is 32,000 units, each costing $166.06. The desired ending inventory for each...
1.2.
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below. 1st Quarter 34,800 2nd Quarter 36,00 3rd Quarter 27, cee 4th Quarter 3 2,888 Budgeted unit sales The company's variable selling and administrative expense per unit is $3.30. Fixed selling and administrative expenses Include advertising expenses of $11,000 per quarter, executive salaries of $53,000 per quarter, and depreciation of $33,000 per quarter. In addition, the company will make Insurance payments of $4,000 in the first quarter...
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: January 40,000 February 50,000 March 60,000 April 60,000 May 62,000 The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: 1 a. Finished goods inventory on January 1 is 32,000 units, each costing $166.06. The desired ending inventory...