Questions
Weighted Average Cost Flow Method Under Perpetual Inventory System The following units of a particular item...

Weighted Average Cost Flow Method Under Perpetual Inventory System

The following units of a particular item were available for sale during the calendar year:

Jan. 1 Inventory 4,000 units at $40
Apr. 19 Sale 2,500 units
June 30 Purchase 4,500 units at $44
Sept. 2 Sale 5,000 units
Nov. 15 Purchase 2,000 units at $46

The firm uses the weighted average cost method with a perpetual inventory system. Determine the cost of goods sold for each sale and the inventory balance after each sale. Present the data in the form illustrated in Exhibit 5.

Schedule of Cost of Goods Sold
Weighted Average Cost Flow Method
Purchases Cost of Goods Sold Inventory
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
Jan. 1 - - -
Apr. 19 - - - - - -
June 30 - - - - - -
Sept. 2 - - - - - -
Nov. 15 - - - - - -
Dec. 31 Balances - - - -


In: Accounting

Forecasting labour costs is a key aspect of hotel revenue management that enables hoteliers to appropriately...

Forecasting labour costs is a key aspect of hotel revenue management that enables hoteliers to appropriately allocate hotel resources and fix pricing strategies. Mary, the President of Hellenic Hoteliers Federation (HHF) is interested in investigating how labour costs (variable L_COST) relate to the number of rooms in a hotel (variable Total_Rooms). Suppose that HHF has hired you as a business analyst to develop a linear model to predict hotel labour costs based on the total number of rooms per hotel using the data provided. 3.1 Use the least squares method to estimate the regression coefficients b0 and b1 3.2 State the regression equation 3.3 Plot on the same graph, the scatter diagram and the regression line 3.4 Give the interpretation of the regression coefficients b0 and b1 as well as the result of the t-test on the individual variables (assume a significance level of 5%) Determine the correlation coefficient of the two variables and provide an interpretation of its meaning in the context of this problem.Check statistically, at the 0.05 level of significance whether there is any evidence of a linear relationship between labour cost and total number of rooms per hotel

STARS Total_Rooms Region_ID ARR_MAY ARR_AUG L_COST
5 412 1 95 160 2.165.000
5 313 1 94 173 2.214.985
5 265 1 81 174 1.393.550
5 204 1 131 225 2.460.634
5 172 1 90 195 1.151.600
5 133 1 71 136 801.469
5 127 1 85 114 1.072.000
4 322 1 70 159 1.608.013
4 241 1 64 109 793.009
4 172 1 68 148 1.383.854
4 121 1 64 132 494.566
4 70 1 59 128 437.684
4 65 1 25 63 83.000
3 93 1 76 130 626.000
3 75 1 40 60 37.735
3 69 1 60 70 256.658
3 66 1 51 65 230.000
3 54 1 65 90 200.000
2 68 1 45 55 199.000
1 57 1 35 90 11.720
4 38 1 22 51 59.200
4 27 1 70 100 130.000
3 47 1 60 120 255.020
3 32 1 40 60 3.500
3 27 1 48 55 20.906
2 48 1 52 60 284.569
2 39 1 53 104 107.447
2 35 1 80 110 64.702
2 23 1 40 50 6.500
1 25 1 59 128 156.316
4 10 1 90 105 15.950
3 18 1 94 104 722.069
2 17 1 29 53 6.121
2 29 1 26 44 30.000
1 21 1 42 54 5.700
1 23 1 30 35 50.237
2 15 1 47 50 19.670
1 8 1 31 49 7.888
1 15 1 40 55 3.500
1 18 1 35 40 112.181
4 10 1 57 97 30.000
2 26 1 35 40 3.575
5 306 2 113 235 2.074.000
5 240 2 61 132 1.312.601
5 330 2 112 240 434.237
5 139 2 100 130 495.000
4 353 2 87 152 1.511.457
4 324 2 112 211 1.800.000
4 276 2 95 160 2.050.000
4 221 2 47 102 623.117
4 200 2 77 178 796.026
4 117 2 48 91 360.000
3 170 2 60 104 538.848
3 122 2 25 33 568.536
5 57 2 68 140 300.000
4 62 2 55 75 249.205
3 98 2 38 75 150.000
3 75 2 45 70 220.000
3 62 2 45 90 50.302
5 50 2 100 180 517.729
4 27 2 180 250 51.000
3 44 2 38 84 75.704
3 33 2 99 218 271.724
3 25 2 45 95 118.049
2 30 2 30 55 40.000
3 10 2 40 70 10.000
2 18 2 60 100 10.000
2 73 2 22 41 70.000
2 21 2 55 100 12.000
1 22 2 40 100 20.000
1 25 2 80 120 36.277
1 25 2 80 120 36.277
1 31 2 18 35 10.450
3 16 2 80 100 14.300
2 15 2 30 45 4.296
1 16 2 25 70 379.498
1 22 2 30 35 1.520
4 12 2 215 265 45.000
4 34 2 133 218 96.619
2 37 2 35 95 270.000
2 25 2 100 150 60.000
2 10 2 70 100 12.500
5 270 3 60 90 1.934.820
5 261 3 119 211 3.000.000
5 219 3 93 162 1.675.995
5 280 3 81 138 903.000
5 378 3 44 128 2.429.367
5 181 3 100 187 1.143.850
5 166 3 98 183 900.000
5 119 3 100 150 600.000
5 174 3 102 211 2.500.000
5 124 3 103 160 1.103.939
4 112 3 40 56 363.825
4 227 3 69 123 1.538.000
4 161 3 112 213 1.370.968
4 216 3 80 124 1.339.903
3 102 3 53 91 173.481
4 96 3 73 134 210.000
4 97 3 94 120 441.737
4 56 3 70 100 96.000
3 72 3 40 75 177.833
3 62 3 50 90 252.390
3 78 3 70 120 377.182
3 74 3 80 95 111.000
3 33 3 85 120 238.000
3 30 3 50 80 45.000
3 39 3 30 68 50.000
3 32 3 30 100 40.000
2 25 3 32 55 61.766
2 41 3 50 90 166.903
2 24 3 70 120 116.056
2 49 3 30 73 41.000
2 43 3 94 120 195.821
2 20 3 70 120 96.713
2 32 3 19 45 6.500
2 14 3 35 70 5.500
2 14 3 50 80 4.000
1 13 3 25 45 15.000
1 13 3 30 50 9.500
2 53 3 55 80 48.200
3 11 3 95 120 3.000
1 16 3 25 31 27.084
1 21 3 16 40 30.000
1 21 3 16 40 20.000
1 46 3 19 23 43.549
1 21 3 30 40 10.000

In: Statistics and Probability

Which of the following is true regarding the production and pricing decisions of monopolistically competitive firms?...

Which of the following is true regarding the production and pricing decisions of monopolistically competitive firms? Monopolistically competitive firms choose the quantity at which marginal cost equals ________ and then use the _________ curve to determine the price that is consistent with this particular quantity.
A. average total cost; demand
B. average variable cost; demand
C. average total cost; supply
D. marginal revenue; demand
E. marginal revenue; supply

14. When a firm operates in a state of excess capacity,
A. it must be operating in a monopolistically competitive market.
B. additional production would increase average total cost.
C. additional production would decrease the average total cost.
D. A and B, only
E. A and C, only
15. A monopolistically competitive firm is currently producing 15,000 units of output. At this level of output the firm is charging a price equal to $10, has marginal revenue equal to $6, has marginal cost equal to $6, and has average total cost equal to $12. From this information we can infer that
A. the firm is currently maximizing its profit or minimizing its loss.
B. the profits of the firm are equal to negative $30,000.
C. firms are likely to enter this market in the long run.
D. All of the above are correct.
E. A and B, only

In: Economics

A perfectly competitive firm faces a market-determined price of $30 for its product. Fill in columns...

A perfectly competitive firm faces a market-determined price of $30 for its product. Fill in columns and answer the question below.

(1)

(2)

(3)

(4)

(5)

(6)

(7)

Quantity

Total cost

Average total cost

Marginal cost

Marginal revenue

Profit margin

Total profit

0

$1,500

150

$4,000

300

$6,600

450

$9,600

600

$14,000

750

$19,200

The competitive firm should produce _____ units to maximize profit.

In: Economics

Please complete the weighted average information with the information provided. (Not all information provided may be...

Please complete the weighted average information with the information provided. (Not all information provided may be relevant in completing the question).

Inventory Information
Inventory on hand at the beginning of October:
Units Cost / unit Total Cost
Purchase # 1 15 60 $900
Purchase # 2 25 70 1,750
40 $2,650
October 2018 transactions related to buying and selling widget inventory
1-Oct Sold 30 widgets at $125 each on credit
3-Oct Purchased 60 widgets at a cost of $80 per widget on credit
10-Oct Sold 45 widgets at $150 each on credit
20-Oct Purchased 40 widgets at a cost of $85 per widget on credit
24-Oct Sold 35 widgets at $165 each on credit

The PHYSICAL count of widget inventory on hand at October 31, 2018 shows 23 widgets at a FIFO cost of $1,955.

Number of Days Outstanding
Total 0-30 31-60 61-90 91-120 over 120
Accounts Receivable $     163,075 $146,768 $     6,523 $     3,262 $     4,892 $     1,631
% Uncollectible 0.02 0.06 0.075 0.08 0.09
Estimated Uncollectible $         4,109         2,935            391            245            391            147
Beginning Inventory Units Cost / unit Cost
15         60             900
25 70          1,750
40          2,650
Weighted Avg
Purchases Cost of Goods Sold Inventory on Hand
Unit Total   Unit Total   Unit Total  
Date Quantity Cost Cost   Quantity Cost Cost   Quantity Cost Cost  
Beg Inv 15              60                    900 15               60                900
25 70                 1,750 25 70            1,750
40 66.25            2,650

In: Accounting

Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...

Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown:

Hi-Tek Manufacturing Inc.
Income Statement
Sales $ 1,704,000
Cost of goods sold 1,251,609
Gross margin 452,391
Selling and administrative expenses 610,000
Net operating loss $ (157,609 )

Hi-Tek produced and sold 60,000 units of B300 at a price of $20 per unit and 12,600 units of T500 at a price of $40 per unit. The company’s traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company’s two product lines is shown below:

B300 T500 Total
Direct materials $ 400,600 $ 163,000 $ 563,600
Direct labor $ 120,600 $ 42,800 163,400
Manufacturing overhead 524,609
Cost of goods sold $ 1,251,609

The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek’s ABC implementation team concluded that $51,000 and $105,000 of the company’s advertising expenses could be directly traced to B300 and T500, respectively. The remainder of the selling and administrative expenses was organization-sustaining in nature. The ABC team also distributed the company’s manufacturing overhead to four activities as shown below:

Manufacturing
Overhead
Activity
Activity Cost Pool (and Activity Measure) B300 T500 Total
Machining (machine-hours) $ 212,809 90,300 62,800 153,100
Setups (setup hours) 150,000 75 300 375
Product-sustaining (number of products) 101,000 1 1 2
Other (organization-sustaining costs) 60,800 NA NA NA
Total manufacturing overhead cost $ 524,609

Required:

2. Compute the product margins for B300 and T500 under the activity-based costing system.

3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.

-----

2. Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.)

B300 T500 Total
Product margin $0


3.

Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2 decimal places and "Percentage" answers to 1 decimal place and other answers to the nearest whole dollar amounts.)

B300 T500 Total
% of % of
Amount Amount Amount
Traditional Cost System
% %
% %
% %
Total cost assigned to products $0 $0 $0
Total cost $0
B300 T500 Total
% of % of
Amount Total Amount Amount Total Amount Amount
Activity-Based Costing System
Direct costs:
% %
% %
% %
Indirect costs:
% %
% %
% %
Total cost assigned to products $0 $0 0
Costs not assigned to products:
Total cost $0

In: Accounting

Consider the following hourly demand and cost schedule for a firm facing a fixed price (Tπ...

Consider the following hourly demand and cost schedule for a firm facing a fixed price (Tπ is Total Profit).

Q

P

Tr

Mr

TFC

TVC

TC

MC

ATC

AVC

T(π)

0

$5.00

$4.00

1

4

2

2

3

1

4

2

5

3

6

4

7

5

8

6

9

7

10

8

                                                                                                                                     

Complete the columns for TR, MR, TFC, TVC, TC, ATC, AVC, and MC, as well as those for (TC), TVC, & TFC. Draw the curves for Demand (Price Vs. Quantity), MR (Marginal Revenue), ATC, AVC, and MC, all in one diagram. Also draw the Total Revenue (TR), Total Cost (TC), TVC, and TFC in a second diagram right below the first one.

  1. Determine, in order to maximize profit. How many units this firm should produce and explain.
  2. Demonstrate the geometric areas (rectangles) of Total Revenue, Total Cost and Total Profit at the profit-maximizing level and calculate the values of each in the diagram above (and not the one below).
  3. Show the Total Revenue, Total Cost and Total Profit at the profit-maximizing level in the diagram below.

I've given all the information that I have.

In: Economics

Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...

Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown:

Hi-Tek Manufacturing Inc.
Income Statement
Sales $ 1,649,700
Cost of goods sold 1,232,216
Gross margin 417,484
Selling and administrative expenses 560,000
Net operating loss $ (142,516 )

Hi-Tek produced and sold 60,300 units of B300 at a price of $19 per unit and 12,600 units of T500 at a price of $40 per unit. The company’s traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company’s two product lines is shown below:

B300 T500 Total
Direct materials $ 400,000 $ 162,700 $ 562,700
Direct labor $ 120,400 $ 42,500 162,900
Manufacturing overhead 506,616
Cost of goods sold $ 1,232,216

The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek’s ABC implementation team concluded that $59,000 and $101,000 of the company’s advertising expenses could be directly traced to B300 and T500, respectively. The remainder of the selling and administrative expenses was organization-sustaining in nature. The ABC team also distributed the company’s manufacturing overhead to four activities as shown below:

Manufacturing
Overhead
Activity
Activity Cost Pool (and Activity Measure) B300 T500 Total
Machining (machine-hours) $ 199,906 90,000 62,600 152,600
Setups (setup hours) 144,910 77 260 337
Product-sustaining (number of products) 101,400 1 1 2
Other (organization-sustaining costs) 60,400 NA NA NA
Total manufacturing overhead cost $ 506,616

Required:

1.

Compute the product margins for the B300 and T500 under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.)

B300 T500 Total
Product margin $0

2.

Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.)

B300 T500 Total
Product margin

$0

3.

Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2 decimal places and "Percentage" answers to 1 decimal place and and other answers to the nearest whole dollar amounts.)

B300 T500 Total
% of % of
Amount Amount Amount
Traditional Cost System
% %
% %
% %
Total cost assigned to products $0 $0 $0
Total cost $0
B300 T500 Total
% of % of
Amount Total Amount Amount Total Amount Amount
Activity-Based Costing System
Direct costs:
% %
% %
% %
Indirect costs:
% %
% %
% %
Total cost assigned to products $0 $0 0
Costs not assigned to products:
  
Total cost $0

In: Accounting

Martinez Company’s relevant range of production is 9,500 units to 14,500 units. When it produces and...

Martinez Company’s relevant range of production is 9,500 units to 14,500 units. When it produces and sells 12,000 units, its unit costs are as follows:

Amount
Per Unit

  Direct materials

$

6.80

  Direct labour

$

4.30

  Variable manufacturing overhead

$

1.60

  Fixed manufacturing overhead

$

4.80

  Fixed selling expense

$

3.80

  Fixed administrative expense

$

2.20

  Sales commissions

$

1.20

  Variable administrative expense

$

0.45

1. 1. For financial accounting purposes, what is the total amount of product costs incurred to make 12,000 units?

2. . For financial accounting purposes, what is the total amount of period costs incurred to sell 12,000 units?

3. If 10,000 units are sold, what is the variable cost per unit sold? (Round your answer to 2 decimal places.)

4. If 12,000 units are sold, what is the variable cost per unit sold? (Round your answer to 2 decimal places.)

5. 5. If 10,000 units are sold, what is the total amount of variable costs related to the units sold?

6. If 12,000 units are sold, what is the total amount of variable costs related to the units sold?

7. If 10,000 units are produced, what is the average fixed manufacturing cost per unit produced? (Round your answer to 2 decimal places.)

8. If 12,000 units are produced, what is the average fixed manufacturing cost per unit produced? (Round your answer to 2 decimal places.)

9. If 10,000 units are produced, what is the total amount of fixed manufacturing cost incurred to support this level of production?

10. If 12,000 units are produced, what is the total amount of fixed manufacturing cost incurred to support this level of production?

11-a. If 10,000 units are produced, what is the total amount of manufacturing overhead cost incurred to support this level of production?

11-b. If 10,000 units are produced, What is this total amount of manufacturing overhead cost expressed on a per unit basis? (Round your answer to 2 decimal places.)

12-a. If 12,000 units are produced, what is the total amount of manufacturing overhead cost incurred to support this level of production?

12-b. If 12,000 units are produced, what is this total amount of manufacturing overhead cost expressed on a per unit basis? (Round your answer to 2 decimal places.)

13-a. If 10,000 units are produced, what are the total amounts of direct manufacturing costs incurred to support this level of production?

13-b. If 10,000 units are produced, what are the total amounts of indirect manufacturing costs incurred to support this level of production?

14. What total incremental cost will Martinez incur if it increases production from 12,000 to 12,001 units? (Round your answer to 2 decimal places.)

I need my answers in numbers only

In: Accounting

Martinez Company’s relevant range of production is 7,900 units to 12,900 units. When it produces and...

Martinez Company’s relevant range of production is 7,900 units to 12,900 units. When it produces and sells 10,400 units, its unit costs are as follows:

Amount
Per Unit
  Direct materials $ 6.60
  Direct labor $ 4.10
  Variable manufacturing overhead $ 1.50
  Fixed manufacturing overhead $ 4.60
  Fixed selling expense $ 3.60
  Fixed administrative expense $ 2.00
  Sales commissions $ 1.00
  Variable administrative expense $ 0.50
Required:
1.

For financial accounting purposes, what is the total amount of product costs incurred to make 10,400 units?

2.

For financial accounting purposes, what is the total amount of period costs incurred to sell 10,400 units

3.

If 8,400 units are sold, what is the variable cost per unit sold? (Round your answer to 2 decimal places.)

4.

If 12,900 units are sold, what is the variable cost per unit sold? (Round your answer to 2 decimal places.)

5. If 8,400 units are sold, what is the total amount of variable costs related to the units sold?
6. If 12,900 units are sold, what is the total amount of variable costs related to the units sold?
7.

If 8,400 units are produced, what is the average fixed manufacturing cost per unit produced? (Round your answer to 2 decimal places.)

8.

If 12,900 units are produced, what is the average fixed manufacturing cost per unit produced? (Round your answer to 2 decimal places.)

9.

If 8,400 units are produced, what is the total amount of fixed manufacturing cost incurred to support this level of production?

10.

If 12,900 units are produced, what is the total amount of fixed manufacturing cost incurred to support this level of production?

      

11-a.

If 8,400 units are produced, what is the total amount of manufacturing overhead cost incurred to support this level of production?

            
  

11-b.

If 8,400 units are produced, what is the total amount of manufacturing overhead cost expressed on a per unit basis? (Round your answer to 2 decimal places.)

12-a.

If 12,900 units are produced, what is the total amount of manufacturing overhead cost incurred to support this level of production?


                

12-b.

If 12,900 units are produced, what is the total amount of manufacturing overhead cost expressed on a per unit basis? (Round your answer to 2 decimal places.

13.

If the selling price is $22.60 per unit, what is the contribution margin per unit sold? (Round your answer to 2 decimal places.)

14-a.

If 11,400 units are produced, what are the total amount of direct manufacturing costs incurred to support this level of production

     

14-b.

If 11,400 units are produced, what are the total amount of indirect manufacturing costs incurred to support this level of production?

15.

What total incremental cost will Martinez incur if it increases production from 10,400 to 10,401 units? (Round your answer to 2 decimal places.)

In: Accounting