Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information Technology Auditing

Authors: Hall, J Scott Harr

3rd Edition

1133008046, 978-1439079119

More Books

Students also viewed these Accounting questions