Question

In: Accounting

Fortune, Inc., is preparing its master budget for the first quarter. The company sells a single...

Fortune, Inc., is preparing its master budget for the first quarter. The company sells a single product at a price of $25 per unit. Sales (in units) are forecasted at 41,000 for January, 61,000 for February, and 51,000 for March. Cost of goods sold is $12 per unit. Other expense information for the first quarter follows.

Commissions 9 % of sales dollars
Rent $ 18,000 per month
Advertising 13 % of sales dollars
Office salaries $ 72,000 per month
Depreciation $ 53,000 per month
Interest 13 % annually on a $240,000 note payable
Tax rate 30 %

  
Prepare a budgeted income statement for this first quarter. (Round your final answers to the nearest whole dollar.)

FORTUNE, INC.
Budgeted Income Statement
For Quarter Ended March 31
Operating expenses
0
$0

Solutions

Expert Solution

Total budgeted unit sales for the quarter

Jan

             41,000

Feb

             61,000

Mar

             51,000

Total

          153,000

FORTUNE, INC.

Budgeted Income Statement

For Quarter Ended March 31

Sales Revenue (153,000*$25)

$3,825,000

Less: Cost of goods sold (153,000*12)

$1,836,000

Gross profit

$1,989,000

Other Expenses:

Commissions (9%*3,825,000)

$344,250

Rent (18,000*3months)

$54,000

Advertising (13%*3,825,000)

$497,250

Office salaries (72,000*3)

$216,000

Depreciation (53,000*3)

$159,000

Interest (240,000*13%*3/12)

$7,800

$1,278,300

Net profit (Gross profit-Other exp)

$710,700

Less: Tax " 30%

$213,210

Net profit after tax

$497,490


Related Solutions

Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalton ​Manufacturing's operations: Current Assets as of December 31 (prior year): Cash. . . . . . . . . . . . . . . . . . . . . . . . . . .$4,460 Accounts receivable, net. . . . . . . . . . . $48,000 Inventory. . . . . . . ....
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalton ​Manufacturing's operations: Current Assets as of December 31 (prior year): Cash. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $4,460 Accounts receivable, net. . . . . . . . . . . . . $46,000 Inventory....
Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Jesper Manufacturing's operations: Current Assets of December 31 (prior year): Cash $4,460 Accounts receivable, net $52,000 Inventory $15,400 Property, plant and equipment, net $122,000 Accounts payable $44,000 Common stock $126,860 Retained earning $23,000 a. Actual sales in December were $76,000. Selling price per unit is projected to remain stable at $9 per unit throughout the budget period. Sales for the...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalton ​Manufacturing's operations: Current Assets as of December 31 (prior year): Cash. . . . . . . . . . . . . . . . . . . . . . . . . . .$4,460 Accounts receivable, net. . . . . . . . . . . $48,000 Inventory. . . . . . . ....
Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Jesper Manufacturing's operations: Current Assets as of December 31 (prior year):      Cash            $4,460      Accounts receivable, net $52,000      Inventory $15,400 Property, plant, and equipment, net $122,000 Accounts payable $44,000 Common stock $126,860 Retained earnings $23,000 Actual sales in December were $76,000. Selling price per unit is projected to remain stable at $9 per unit throughout the budget period. Sales for the...
Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Decker ​Manufacturing's operations:    LOADING... ​(Click the icon to view additional​ data.)Read the requirements LOADING... . Requirement 1. Prepare a schedule of cash collections for​ January, February, and​ March, and for the quarter in total. Decker Manufacturing Cash Collections Budget For the Quarter Ended March 31 Month January February March Quarter Cash sales $24,000 $27,600 $29,700 Credits sales Total cash...
Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Jesper Manufacturing's operations: Current Assets as of December 31 (prior year):      Cash           $4,460      Accounts receivable, net $52,000      Inventory $15,400 Property, plant, and equipment, net $122,000 Accounts payable $44,000 Common stock $126,860 Retained earnings $23,000 Actual sales in December were $76,000. Selling price per unit is projected to remain stable at $9 per unit throughout the budget period....
Derry Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Derry Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Derry Manufacturing's operations: Current Assets as of December 31 (prior year): Cash. . . . . . . . . . . . . . . . . . . . . . . . . . . $4,500 Accounts receivable, net. . . . . . . . . . . . . . . $46,000 Inventory. . ....
Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to JesperJesper ​Manufacturing's operations: Data Table Current Assets as of December 31 (prior year): Cash. . . . . . . . . . . . . . . . . . . . . . . . . . . $4,640 Accounts receivable, net. . . . . . . . . . . . . . . $51,000 Inventory....
Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Decker Manufacturing's operations 1: Data Table Current Assets as of December 31 (prior year): Cash $ 4,600 Accounts receivable, net $ 46,000 Inventory $ 15,500 Property, plant, and equipment, net $ 123,000 Accounts payable $ 43,000 Capital stock $ 124,000 Retained earnings $ 22,700 a. Actual sales in December were $71,000. Selling price per unit is projected to remain stable...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT