Question: Complete the table using the figures provided for the three products: A, B and C. Last months budget for sales Product Cost price Sale price

Complete the table using the figures provided for the three products: A, B and C.

Last months budget for sales

Product

Cost price

Sale price

Budget sales last month

Total costs on sales

Budget profit last month

Profit % per item on sale price

#

$

per item

on sales

A

$7.50

$12.00

500

$6,000

$3,750

$4.50

$2,250

38%

B

$9.25

$17.00

400

$6,800

$3,700

$7.75

$3,100

46%

C

$10.00

$30.00

300

$9,000

$3,000

$20.00

$6,000

67%

Total

1,200

$21,800

$10,450

$11,350

Last months sales (actuals)

Product

Cost price

Sale price

Total sales last month

Total costs on sales

Gross profit last month

Profit % per item on sale price

#

$

per item

on sales

A

$7.50

$12.00

650

$7,800

$4,875

$4.50

$2,925

38%

B

$9.25

$17.00

500

$8,500

$4,625

$7.75

$3,875

46%

C

$10.00

$30.00

200

$6,000

$2,000

$20.00

$4,000

67%

Total

1,350

$22,300

$11,500

$10,800

Product

Gross profit budget ($)

Gross profit actual ($)

Variance ($)

A

B

C

Total

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!