Question

In: Accounting

Category Dollars Percent Sales 100% Food Cost $2,375 37% Labor Cost 29% Overhead 24% Profit 10%...

Category Dollars Percent
Sales 100%
Food Cost $2,375 37%
Labor Cost 29%
Overhead 24%
Profit 10%
Category Dollars Percent
Sales 100%
Food Cost 31%
Labor Cost $17,322 34%
Overhead 32%
Profit 3%
Category Dollars Percent
Sales 100%
Food Cost 40%
Labor Cost 29%
Overhead $234 19%
Profit 12%
Category Dollars Percent
Sales $7,700 100%
Food Cost 43%
Labor Cost 32%
Overhead 21%
Profit 4%

Using the figures provided below calculate the missing dollaramounts for each of the Simplified Profit and Loss Statements.

Solutions

Expert Solution

  • All working forms part of the answer
  • All requirements are completed in their sequential order, along with workings:

Requirement 1

A

Food Cost

$                                 2,375

B

% of Sale

37%

C = A/B

Amount of Sales

$                                 6,419

D = C x 100%

Sales

$                                 6,419

E = C x 37%

Food Cost

$                                 2,375

F = C x 29%

Labor Cost

$                                 1,862

G = C x 24%

Overhead

$                                 1,541

H = C x 10%

Profits

$                                     642

Requirement 2

A

Labor Cost

$                               17,322

B

% of Sale

34%

C = A/B

Amount of Sales

$                               50,947

D = C x 100%

Sales

$                               50,947

E = C x 31%

Food Cost

$                               15,794

F = C x 34%

Labor Cost

$                               17,322

G = C x 32%

Overhead

$                               16,303

H = C x 3%

Profits

$                                 1,528

Requirement 3

A

Overhead

$                                     234

B

% of Sale

19%

C = A/B

Amount of Sales

$                                 1,232

D = C x 100%

Sales

$                                 1,232

E = C x 40%

Food Cost

$                                     493

F = C x 29%

Labor Cost

$                                     357

G = C x 19%

Overhead

$                                     234

H = C x 12%

Profits

$                                     148

Requirement 4

A

Sales

$                                 7,700

B

% of Sale

100%

C = A/B

Amount of Sales

$                                 7,700

D = C x 100%

Sales

$                                 7,700

E = C x 43%

Food Cost

$                                 3,311

F = C x 32%

Labor Cost

$                                 2,464

G = C x 21%

Overhead

$                                 1,617

H = C x 4%

Profits

$                                     308


Related Solutions

VS uses Direct-labor cost in dollars to allocate its overhead. For the year of 2013; •...
VS uses Direct-labor cost in dollars to allocate its overhead. For the year of 2013; • No beginning inventories • Estimated overhead at Jan 1st , $2,000,000 and estimated Direct-labor cost, $400,000 • Actual overhead for the year, $2,825,000 • During the year, VS started producing 30,000, finished 25,000 and sold 21,000 units • Other information for the year: WIP FG COGS DM in $85,000 $62,000 $320,000 DL in $60,000 $57,000 $468,000 VS uses the prorate approach to distribute overapplied...
HBM, Inc. had sales of $9 million and a net profit margin of 10 percent in...
HBM, Inc. had sales of $9 million and a net profit margin of 10 percent in 20X0. Management expects sales to grow to $10.8 million and $12.6 million in 20X1 and 20X2, respectively. Management wants to know if additional funds will be necessary to finance this anticipated growth. Currently, the firm is not operating at full capacity and should be able to sustain a 25 percent increase in sales. However, further increases in sales will require $3 million in plant...
Morton Company has two divisions. Sales, direct materials cost, direct labor cost, and manufacturing overhead data...
Morton Company has two divisions. Sales, direct materials cost, direct labor cost, and manufacturing overhead data for Morton’s two divisions are available below. Note: All of Morton Company’s products are sold in competitive markets.                                                                     Missile                                Salt                                                                  Products                       Products Sales                                                     $1,500,000                    $1,000,000 Direct labor                                            (800,000)                       (300,000) Direct materials                                     (100,000)                         (40,000) Manufacturing overhead*                    (400,000)                       (150,000) Gross profit                                            $200,000                        $510,000    *Manufacturing overhead is allocated to production based on the amount of direct labor cost.            Morton has determined that its total...
Morton Company has two divisions. Sales, direct materials cost, direct labor cost, and manufacturing overhead data...
Morton Company has two divisions. Sales, direct materials cost, direct labor cost, and manufacturing overhead data for Morton’s two divisions are available below. Note: All of Morton Company’s products are sold in competitive markets. Missile Salt Products Products Sales $1,500,000 $1,000,000 Direct labor (800,000) (300,000) Direct materials (100,000) (40,000) Manufacturing overhead* (400,000) (150,000) Gross profit $200,000 $510,000 *Manufacturing overhead is allocated to production based on the amount of direct labor cost. Morton has determined that its total manufacturing overhead cost...
9-Morton Company has two divisions. Sales, direct materials cost, direct labor cost, and manufacturing overhead data...
9-Morton Company has two divisions. Sales, direct materials cost, direct labor cost, and manufacturing overhead data for Morton’s two divisions are available below. Note: All of Morton Company’s products are sold in competitive markets. Missile Salt Products Products Sales                                                  $1,500,000                       $1,000,000 Direct labor                                           (300,000)                          (800,000) Direct materials                                   (100,000)                             (40,000) Manufacturing overhead*                (150,000)                          (400,000) Gross profit                                          $950,000                         ($240,000) *Manufacturing overhead is allocated to production based on the amount of direct labor cost.         Morton has determined that its total manufacturing overhead...
9-Morton Company has two divisions. Sales, direct materials cost, direct labor cost, and manufacturing overhead data...
9-Morton Company has two divisions. Sales, direct materials cost, direct labor cost, and manufacturing overhead data for Morton’s two divisions are available below. Note: All of Morton Company’s products are sold in competitive markets. Missile Salt Products Products Sales                                                  $1,500,000                       $1,000,000 Direct labor                                           (300,000)                          (800,000) Direct materials                                   (100,000)                             (40,000) Manufacturing overhead*                (150,000)                          (400,000) Gross profit                                          $950,000                         ($240,000) *Manufacturing overhead is allocated to production based on the amount of direct labor cost.         Morton has determined that its total manufacturing overhead...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT