Question

In: Accounting

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

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

Last month’s 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 month’s 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

Solutions

Expert Solution

Product Gross profit budget ($) Gross profit actual ($) Variance ($)
A $                          2,250.00 $                        2,925.00 $        675.00
B $                          3,100.00 $                        3,875.00 $        775.00
C $                          6,000.00 $                        4,000.00 $ (2,000.00)
Total $                        11,350.00 $                      10,800.00 $     (550.00)

Related Solutions

A company produces and sells three types of products A, B, and C. The table below...
A company produces and sells three types of products A, B, and C. The table below shows the selling price per unit and the total demand for each product type. $/unit Demand A 5 300 B 6 250 C 7 200 For this purpose, the company can commission any of 7 plants with varying costs. Furthermore, each plant has a fixed capacity (in units) regardless of the type of product made. Production costs and capacities for each of the six...
Complete the following using present value. (Use the Table provided.)
Complete the following using present value. (Use the Table provided.)
Using the Quality Attributes Table document provided, complete a page table of quality attributes. Individual Assignment...
Using the Quality Attributes Table document provided, complete a page table of quality attributes. Individual Assignment – Week Four Complete the following table: Attribute Type Categories within the Attribute Type Example from the program Functional attributes <List the categories of attributes of this type (for example “Boolean”)> <Describe an attribute you can measure in your program (for example, user data integrity)> Operational attributes Usability attributes Business attributes Structural attributes
Use the following contingency table to complete​ (a) and​ (b) below. A B C Total 1...
Use the following contingency table to complete​ (a) and​ (b) below. A B C Total 1 15 35 40 90 2 30 35 45 110 Total 45 70 85 200 (a). Compute the expected frequencies for each cell. (b) Compute χ2STAT. Is it significant at α=0.01​?
Use the following contingency table to complete​ (a) and​ (b) below. A B C Total 1...
Use the following contingency table to complete​ (a) and​ (b) below. A B C Total 1 15 30 45 90 2 45 50 55 150 Total 60 80 100 240 a. Compute the expected frequencies for each cell. A B C 1 2 ​(Type integers or​ decimals.) b. Compute χ2STAT. is it significant at α=0.005​? Set up the null and alternative hypotheses to test. Choose the correct answer below. H0​: πA= πB= πC H1​:Not all πj are equal​ (where j=​A,...
-Let O (0,0,0) be the origin and A(a+1,b,c) where a,b and c are the last three...
-Let O (0,0,0) be the origin and A(a+1,b,c) where a,b and c are the last three digits of your student ID. Find, describe and sketch the set of points P such that OP is perpendicular to AP - Let u=<a , b+1 , c+1> find and describe all vectors v such that |u x v|=|u| a=1 , b=1 , c=9
Amazon ltd produces three products; A, B, C and D using the same processing plant. The...
Amazon ltd produces three products; A, B, C and D using the same processing plant. The following information relates to the company: Product                                  A                     B                     C                     D Units produced                      2,000               20,000             2,400               28,000 Material cost per unit (sh)    20                    20                    64                    68 Labour hours per unit                      2                      2                      8                      6 Machine hours per unit        1                      1                      4                      6 Labour cost per unit (sh)      12                    12                    48                    36 The cost accountant analysed the production overheads recorded under the...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit):...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit): Product A B C Selling price $ 84.00 $ 70.00 $ 74.00 Variable expenses: Direct materials 25.20 21.00 9.00 Other variable expenses 25.20 31.50 42.80 Total variable expenses 50.40 52.50 51.80 Contribution margin $ 33.60 $ 17.50 $ 22.20 Contribution margin ratio 40 % 25 % 30 % The company estimates that it can sell 750 units of each product per month. The same...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit):...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit): Product A B C Selling price $ 88.00 $ 72.00 $ 78.00 Variable expenses: Direct materials 26.40 18.00 9.00 Other variable expenses 26.40 36.00 45.60 Total variable expenses 52.80 54.00 54.60 Contribution margin $ 35.20 $ 18.00 $ 23.40 Contribution margin ratio 40 % 25 % 30 % The company estimates that it can sell 900 units of each product per month. The same...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit):...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit): Product A B C Selling price $ 88.00 $ 72.00 $ 78.00 Variable expenses: Direct materials 26.40 18.00 9.00 Other variable expenses 26.40 36.00 45.60 Total variable expenses 52.80 54.00 54.60 Contribution margin $ 35.20 $ 18.00 $ 23.40 Contribution margin ratio 40 % 25 % 30 % The company estimates that it can sell 900 units of each product per month. The same...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT