1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Lana71 [14]
3 years ago
6

Describing How to Save Workbooks

Business
1 answer:
Vinil7 [7]3 years ago
5 0
Save a workbook in another file format
Open the workbook you want to save.
Click File > Save As.
Under Places, pick the place where you want to save the workbook. ...
In the Save As dialog box, navigate to the location you want.
In the Save as type list, click the file format you want.
You might be interested in
Using FIFO for Multiproduct Inventory Transactions (Chapters 6 and 7) [LO 6-3, LO 6-4, LO 7-3] Skip to question [The following i
expeople1 [14]

Answer:

1-a. Dollars of gross profit from selling tags = $9,180

1-b. Dollars of gross profit from selling cases = $1,500

1-c. Gross profit percentage from selling tags = 72.86%

1.d. Gross profit percentage from selling cases = 83.33%

2-a. Tag yields more dollars of profit.

2-b. Tag yields more profit per dollar of sales.

Explanation:

Note: The requirements for this question are two not three as erroneously stated. This is because, the first and the third question are the same. Therefore, the two relevant requirements of the question are:

1. Calculate the dollars of gross profit and the gross profit percentage from selling tags and cases.

2. Which product line yields more dollars of profit? - Which product line yields more profit per dollar of sales?

The explanation of the answers is now given as follows:

1. Calculate the dollars of gross profit and the gross profit percentage from selling tags and cases.

Sales revenue from tags = Sales value of 160 tags mailed to customers on Jan. 8 at a price of $30 per tag + Sales value of 260 tags mailed to customers on Jan. 21 at a price of $30 per tag = (160 * $30) + (260 * $30) = $12,600

Sales revenue from cases = Sales value of 120 cases mailed to customers on Jan. 19 at a price of $15 per case = 120 * $15 = $1,800

Total number of tags sold = 160 tags mailed to customers + 260 tags mailed to customers on Jan. 21 = 420

Total number of cases sold = 120 cases mailed to customers on Jan. 19 at a price of $15 per case = 120

Using FIFO, we have:

Cost of tags sold = Value of 260 tags purchased on Jan.2 from Xioasi Manufacturing (XM) at a cost of $7 per tag + Value of the remaining 160 (i.e. 420 – 260 = 160) tags sold based on the 360 tags purchased on Jan. 11 from XM at a cost of $10 per tag = (260 * $7) + (160 * $10) = $3,420

Cost of cases sold = Value of 60 cases purchased on Jan.4 from Bachittar Products (BP) at a cost of $2 per case + Value of the remaining 60 cases sold based on the 160 cases purchased on Jan. 14 from BP at a cost of $3 per case = (60 * $2) + (60 * $3) = $300

Therefore, we have:

1-a. Dollars of gross profit from selling tags = Sales revenue from tags - Cost of tags sold = $12,600 - $3,420 = $9,180

1-b. Dollars of gross profit from selling cases = Sales revenue from cases - Cost of cases sold = $1,800 - $300 = $1,500

1-c. Gross profit percentage from selling tags = (Dollars of gross profit from selling tags / Sales revenue from tags) * 100 = ($9,180 / $12,600) * 100 = 72.86%

1.d. Gross profit percentage from selling cases = (Dollars of gross profit from selling cases / Sales revenue from cases) * 100 = 83.33%

2. Which product line yields more dollars of profit? - Which product line yields more profit per dollar of sales?

2-a. Which product line yields more dollars of profit?

From part 1 above, we have:

Dollars of gross profit from selling tags = $9,180

Dollars of gross profit from selling cases = $1,500

Since the dollars of gross profit from selling tags of $9,180 is greater than the dollars of gross profit from selling cases of $1,500, this implies that Tag yields more dollars of profit.

2-b. Which product line yields more profit per dollar of sales?

From part 1 above, we have:

Total number of tags sold = 420

Total number of cases sold = 120

Therefore, we have:

Tag's profit per dollar of sales = Dollars of gross profit from selling tags / Total number of tags sold = $9,180 / 420 = $21.86

Case's profit per dollar of sales = Dollars of gross profit from selling cases / Total number of cases sold = $1,500 / 120 = $12.50

Since Tag's profit per dollar of sales of $21.86 is greater than Case's profit per dollar of sales of $12.50, this implies that Tag yields more profit per dollar of sales.

6 0
3 years ago
Antiques R Us is a mature manufacturing firm. The company just paid a dividend of $11.40, but management expects to reduce the p
drek231 [11]

Answer:

The correct answer is $57.

Explanation:

According to the scenario, the computation of the given data are as follows:

Dividend = $11.40

Growth rate = -0.05

Required rate of return = 0.14

So, we can calculate the price by using following formula:

Price = Dividend × ( 1 + Growth rate) ÷ ( return rate - growth rate)

By putting the value, we get

= $11.4 × ( 1 - 0.05) ÷ ( 0.14 + 0.05)

= $57

3 0
3 years ago
Suppose the fed announced that it is lowering its target interest rate by 75 basis points, or 0.75%. to do this, the fed will us
MAXImum [283]

Suppose the federal reserve (The Fed ) announces that it is lowering its target interest rate by 75
basis points or 0.75% . It would achieve this by shifting the supply curve of the money to the...

8 0
3 years ago
Assume F&S offers a deal whereby enrolling in a new membership for $700 provides a year of unlimited access to facilities an
barxatty [35]

Answer:

a. There are two separate performance obligations in the contract. Gym membership is one performance obligation and the providing 25% discount on yoga classes is another performance obligation.

b. The standalone selling price of annual membership is $720. Therefore, F&S will allocate 28*((700*(30/720+30)) of 700 contract price to the discount voucher on yoga course and the remaining $672 will be allocated to membership.

C. solution is in the image attached.

Explanation:

b. F&S offers a 10% discount on yoga classes to all customers as part of promotional strategy. Therefore a 25% discount voucher provides a customer with an incremental value of 15% (25%-10%). Thus, the estimated stand alone selling price of the discount voucher provided by F&S is $30 ($500  * 15% incremental discount * 40% likelihood of the vouchers being redeemed).

8 0
3 years ago
Howat Corporation earned $360,000 during a period when it had an average of 100,000 shares of common stock outstanding. The comm
kari74 [83]

Answer: Yes they are.

Explanation:

A warrant will be dilutive if it causes the share price of a company to reduce in value when it is exercised and converted into common stock.

The warrant in this scenario will dilute the share value because it is to be exercised at a price that is lower than the current market price of the stock so when it is added to the outstanding shares, it will reduce the market value and dilute the shares.

8 0
3 years ago
Other questions:
  • Suppose you find that prices of stocks before large dividend increases show on average consistently positive abnormal returns. i
    15·1 answer
  • Which of the following would be an example of a service a local government would provide?
    14·1 answer
  • Which of the following is a distinctive feature of metes and bounds descriptions?
    7·1 answer
  • Which type of intellectual property can protect your company's logo?
    7·2 answers
  • Other factors that should be considered before the final decision is made​ are: ​(Choose all that​ apply.) A. What will be the e
    10·1 answer
  • Mark would like to apply for a loan. He should
    12·2 answers
  • Union Local School District has a bond outstanding with a coupon rate of 2.8 percent paid semiannually and 16 years to maturity.
    8·1 answer
  • Gloria just started working for GlenMack. As part of her signing bonus, she received 20 shares of GlenMack stock. Gloria is exci
    7·1 answer
  • I need help with this question please
    7·1 answer
  • Your client has a documentary film coming out next month. They have three separate 30-second promo videos and want to identify w
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!