Starfish Industries’ sales budget for the first quarter of the upcoming year shows budgeted sales of $325,000, $350,000, and $310,000 in January, February, and March, respectively. All sales are made on credit. The cash receipts budget for March shows total cash receipts equal to $306,840. Starfish grants a discount to customers who pay within 10 days of the invoice. Starfish collects 60% of sales within the discount period, 20% in the month of sale but outside the discount period, 20% in the month following sale. What is the discount offered by Starfish, and what is the Accounts Receivable balance that will be reported in the March 31 pro-forma balance sheet?
In: Accounting
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Prepare schedules for cash receipts and cash payments, and determine ending balances for balance sheet. Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2019 and expected service revenues for 2020 are November 2019, $80,000; December 2019, $90,000; January 2020, $100,000; February 2020, $120,000; and March 2020, $140,000. Purchases of landscaping supplies (direct materials) are paid 60% in the month of purchase and 40% the following month. Actual purchases for 2019 and expected purchases for 2020 are December 2019, $14,000; January 2020, $12,000; February 2020, $15,000; and March 2020, $18,000.
Instructions a. Prepare the following schedules for each month in the first quarter of 2020 and for the quarter in total:
1. Expected collections from clients.
2. Expected payments for landscaping supplies.
b. Determine the following balances at March 31, 2020:
1. Accounts receivable.
2. Accounts payable.
In: Accounting
General Lighting During the first quarter of the current year, the company sold 4,000 batteries on credit for $150 each plus state sales tax of 6%. Refer to General Lighting. The price of each battery includes a $1.95 federal excise tax. Any taxes collected must be paid to the appropriate governmental units at the end of the quarter. Which of the following is the proper journal entry to record for the sale of the batteries?
a. Accounts Receivable 636,000, Sales Tax Expense 36,000, Excise Tax Expense 7,800, Sales Revenue 643,800
b. Accounts Receivable 636,000, Sales Revenue 592,200, Sales Tax Payable 36,000, Federal Excise Tax Payable 7,800
c. Accounts Receivable 636,000, Excise Tax Expense 7,800, Sales Revenue 607,800, Sales Tax Payable 36,000
d. Accounts Receivable 643,800, Sales Revenue 600,000, Sales Tax Payable 36,000, Federal Excise Tax Payable 7,800
In: Accounting
Tempo Company's fixed budget (based on sales of 16,000 units)
for the first quarter reveals the following.
| Fixed Budget | ||||||||
| Sales (16,000 units × $216 per unit) | $ | 3,456,000 | ||||||
| Cost of goods sold | ||||||||
| Direct materials | $ | 400,000 | ||||||
| Direct labor | 672,000 | |||||||
| Production supplies | 432,000 | |||||||
| Plant manager salary | 200,000 | 1,704,000 | ||||||
| Gross profit | 1,752,000 | |||||||
| Selling expenses | ||||||||
| Sales commissions | 128,000 | |||||||
| Packaging | 256,000 | |||||||
| Advertising | 100,000 | 484,000 | ||||||
| Administrative expenses | ||||||||
| Administrative salaries | 250,000 | |||||||
| Depreciation—office equip. | 220,000 | |||||||
| Insurance | 190,000 | |||||||
| Office rent | 200,000 | 860,000 | ||||||
| Income from operations | $ | 408,000 | ||||||
(1) Compute the total variable cost per
unit.
(2) Compute the total fixed costs.
(3) Compute the income from operations for sales
volume of 14,000 units.
In: Accounting
Tempo Company's fixed budget (based on sales of 10,000 units)
for the first quarter reveals the following.
| Fixed Budget | ||||||||
| Sales (10,000 units × $212 per unit) | $ | 2,120,000 | ||||||
| Cost of goods sold | ||||||||
| Direct materials | $ | 240,000 | ||||||
| Direct labor | 440,000 | |||||||
| Production supplies | 280,000 | |||||||
| Plant manager salary | 40,000 | 1,000,000 | ||||||
| Gross profit | 1,120,000 | |||||||
| Selling expenses | ||||||||
| Sales commissions | 80,000 | |||||||
| Packaging | 140,000 | |||||||
| Advertising | 100,000 | 320,000 | ||||||
| Administrative expenses | ||||||||
| Administrative salaries | 90,000 | |||||||
| Depreciation—office equip. | 60,000 | |||||||
| Insurance | 30,000 | |||||||
| Office rent | 40,000 | 220,000 | ||||||
| Income from operations | $ | 580,000 | ||||||
(1) Compute the total variable cost per
unit.
(2) Compute the total fixed costs.
(3) Compute the income from operations for sales
volume of 8,000 units.
(4) Compute the income from operations for sales
volume of 12,000 units.
In: Accounting
Tempo Company's fixed budget (based on sales of 18,000 units) for the first quarter reveals the following.
(1)Compute the total variable cost per unit.
(2) Compute the total fixed costs.
(3) Compute the income from operations for sales
volume of 16,000 units.
(4) Compute the income from operations for sales
volume of 20,000 units.
| Fixed Budget | ||||||||
| Sales (18,000 units × $214 per unit) | $ | 3,852,000 | ||||||
| Cost of goods sold | ||||||||
| Direct materials | $ | 450,000 | ||||||
| Direct labor | 774,000 | |||||||
| Production supplies | 504,000 | |||||||
| Plant manager salary | 250,000 | 1,978,000 | ||||||
| Gross profit | 1,874,000 | |||||||
| Selling expenses | ||||||||
| Sales commissions | 144,000 | |||||||
| Packaging | 270,000 | |||||||
| Advertising | 100,000 | 514,000 | ||||||
| Administrative expenses | ||||||||
| Administrative salaries | 300,000 | |||||||
| Depreciation—office equip. | 270,000 | |||||||
| Insurance | 240,000 | |||||||
| Office rent | 250,000 | 1,060,000 | ||||||
| Income from operations | $ | 300,000 | ||||||
In: Accounting
empo Company's fixed budget (based on sales of 12,000 units) for the first quarter reveals the following. Fixed Budget Sales (12,000 units × $219 per unit) $ 2,628,000 Cost of goods sold Direct materials $ 300,000 Direct labor 516,000 Production supplies 312,000 Plant manager salary 100,000 1,228,000 Gross profit 1,400,000 Selling expenses Sales commissions 84,000 Packaging 180,000 Advertising 100,000 364,000 Administrative expenses Administrative salaries 150,000 Depreciation—office equip. 120,000 Insurance 90,000 Office rent 100,000 460,000 Income from operations $ 576,000 (1) Compute the total variable cost per unit. (2) Compute the total fixed costs. (3) Compute the income from operations for sales volume of 10,000 units. (4) Compute the income from operations for sales volume of 14,000 units.
In: Accounting
Tempo Company's fixed budget (based on sales of 18,000 units) for the first quarter reveals the following. Fixed Budget Sales (18,000 units × $217 per unit) $ 3,906,000 Cost of goods sold Direct materials $ 414,000 Direct labor 756,000 Production supplies 504,000 Plant manager salary 214,000 1,888,000 Gross profit 2,018,000 Selling expenses Sales commissions 126,000 Packaging 252,000 Advertising 100,000 478,000 Administrative expenses Administrative salaries 264,000 Depreciation—office equip. 234,000 Insurance 204,000 Office rent 214,000 916,000 Income from operations $ 624,000 (1) Compute the total variable cost per unit. (2) Compute the total fixed costs. (3) Compute the income from operations for sales volume of 16,000 units. (4) Compute the income from operations for sales volume of 20,000 units.
| Fixed Budget | ||||||||
| Sales (18,000 units × $217 per unit) | $ | 3,906,000 | ||||||
| Cost of goods sold | ||||||||
| Direct materials | $ | 414,000 | ||||||
| Direct labor | 756,000 | |||||||
| Production supplies | 504,000 | |||||||
| Plant manager salary | 214,000 | 1,888,000 | ||||||
| Gross profit | 2,018,000 | |||||||
| Selling expenses | ||||||||
| Sales commissions | 126,000 | |||||||
| Packaging | 252,000 | |||||||
| Advertising | 100,000 | 478,000 | ||||||
| Administrative expenses | ||||||||
| Administrative salaries | 264,000 | |||||||
| Depreciation—office equip. | 234,000 | |||||||
| Insurance | 204,000 | |||||||
| Office rent | 214,000 | 916,000 | ||||||
| Income from operations | $ | 624,000 | ||||||
In: Accounting
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
During the first calendar quarter of 2016, Clinton Corporation is planning to manufacture a new product and introduce it in two regions. Market research indicates that sales will be 7,000 units in the urban region at a unit price of $53 and 6,000 units in the rural region at $48 each. Because the sales manager expects the product to catch on, he has asked for production sufficient to generate a 5,000-unit ending inventory. The production manager has furnished the following estimates related to manufacturing costs and operating expenses:
|
Variable |
Fixed |
||||
|---|---|---|---|---|---|
|
(per unit) |
(total) |
||||
| Manufacturing costs: | |||||
| Direct materials | |||||
| A (4 lb. @ $3.15/lb.) | $12.60 | - | |||
| B (2 lb. @ $4.65/lb.) | 9.30 | - | |||
| Direct labor (0.5 hours per unit) | 7.50 | - | |||
| Manufacturing overhead: | |||||
| Depreciation | - | $7,650 | |||
| Factory supplies | 0.90 | 4,500 | |||
| Supervisory salaries | - | 28,800 | |||
| Other | 0.75 | 22,950 | |||
| Operating expenses: | |||||
| Selling: | |||||
| Advertising | - | 22,500 | |||
| Sales salaries& commissions* | 1.50 | 15,000 | |||
| Other* | 0.90 | 3,000 | |||
| Administrative: | |||||
| Office salaries | - | 2,700 | |||
| Supplies | 0.15 | 1,050 | |||
| Other | 0.08 | 1,950 |
*Varies per unit sold, not per unit produced.
a. Assuming that the desired ending inventories of materials A and B are 5,000 and 7,000 pounds, respectively, and that work-in-process inventories are immaterial, prepare budgets for the calendar quarter in which the new product will be introduced for each of the following operating factors:
Do not use negative signs with any of your answers below.
1. Total sales
$Answer
2. Production
Answer
units
3. Material purchase cost
| Material A | Material B | ||||
|---|---|---|---|---|---|
| Total pounds (lbs.) required for production | Answer | Answer | |||
| Desired ending materials inventory | Answer | Answer | |||
| Total pounds to be available | Answer | Answer | |||
| Beginning materials inventory | Answer | Answer | |||
| Total material to be purchased (lbs.) | Answer | Answer | |||
| Total material purchases ($) | Answer | Answer |
4. Direct labor costs
$Answer
5. Manufacturing overhead costs
| Fixed | Variable | Total | |||
|---|---|---|---|---|---|
| Depreciation | Answer | Answer | Answer | ||
| Factory supplies | Answer | Answer | Answer | ||
| Supervisory salaries | Answer | Answer | Answer | ||
| Other | Answer | Answer | Answer | ||
| Total manufacturing overhead | Answer |
6. Selling and administrative expenses
| Fixed | Variable | Total | |||
|---|---|---|---|---|---|
| Selling expenses: | |||||
| Advertising | Answer | Answer | Answer | ||
| Sales salaries and commissions | Answer | Answer | Answer | ||
| Other | Answer | Answer | Answer | ||
| Total selling expenses | Answer | ||||
| Administrative expenses: | |||||
| Office salaries | Answer | Answer | Answer | ||
| Supplies | Answer | Answer | Answer | ||
| Other | Answer | Answer | Answer | ||
| Total administrative expenses | Answer | ||||
| Total selling and administrative expenses | Answer |
b. Using data generated in requirement (a), prepare a budgeted
income statement for the calendar quarter. Assume an overall
effective income tax rate of 30%.
Round answers to the nearest whole number.
Do not use negative signs with your answers.
| Clinton Corporation Budgeted Income Statement For the Quarter Ended March 31, 2016 |
|||||
|---|---|---|---|---|---|
| Sales | Answer | ||||
| Cost of Goods Sold: | |||||
| Beginning Inventory - Finished Goods | Answer | ||||
| Material: | |||||
| Beginning Inventory - Material | Answer | ||||
| Material Purchases | Answer | ||||
| Material Available | Answer | ||||
| Ending Inventory - Material | Answer | ||||
| Direct Material | Answer | ||||
| Direct Labor | Answer | ||||
| Manufacturing Overhead | Answer | ||||
| Total Manufacturing Cost | Answer | ||||
| Cost of Goods Available for Sale | Answer | ||||
| Ending Inventory - Finished Goods | Answer | ||||
| Cost of Goods Sold | Answer | ||||
| Gross Profit | Answer | ||||
| Operating Expenses: | |||||
| Selling Expenses | Answer | ||||
| Administrative Expenses | Answer | ||||
| Total Operating Expenses | Answer | ||||
| Income before Income Taxes | Answer | ||||
| Income Tax Expense | Answer | ||||
| Net Income | Answer | ||||
PreviousSave AnswersNext
In: Accounting