You have been hired to design a relational database for a convenience store which is located within an apartment complex. The goal of the database is to keep track of the inventory sold in hopes of using the data to better meet the customer's convenience store needs. Up until your arrival, the store kept track of each customer’s purchases using a flat database log, as shown in the following table. Using the information provided, build a relational database that will allow for querying things such as products sold, customer purchases, total apartment purchases, and total spent per apartment. Include any created tables and identify the keys and key types that are used. Identify all relationships, labeling them 1:1, 1:N, or M:N.
Name Apt # Products Price Quantity
Joseph Anthony 1125 Orange Juice 4.59 1
Joseph Anthony 1125 Bread Loaf 2.29 1
Yolanda Burns 3221 Milk 3.67 1
Yolanda Burns 3221 Candy Bar 1.19 3
Francis Jordan 1138 Gum 0.99 2
Steve Miller 2221 Gum 0.99 1
Cho Lin 2239 Bread Loaf 2.29 1
Answers
Answer:
Apartment (1)=====> (N) Purchases (M) =====> Product(1).
Explanation:
So, in this question we are given the following; Name, Apt # , Products, Price and Quantity. With this data or parameters or information we will be able to know that there should be another parameters in a table which are;
=> Apartment: with this parameter and the apt # each person or Individual can be Identifed.
=> Purchases: this table will be about the details of the person or Individuals the bought the products and what quantity was bought.
=> Product: here, this parameter can be used in saving or storing the name of each products and the prices of each one of them.
Hence;
(1). APARTMENT = Apt#, Name => where Apt# will be the primary key because it is unique.
(2). PRODUCTS= Products, Price => where product is the unique key.
(3). PURCHASES = Apt #, product quantity => where Apt # is a foreign key and an attribute of product in the ''purchases" table.
Kindly check the attachment for the diagram
Related Questions
Marina had an accident with her car and the repair bill came to $900. She didn't have any emergency fund money and no extra
money in her monthly budget, so she ended up borrowing from a pay-day loan company. As long as she can pay the loan back at
the end of the 30 day period she won't be charged any interest, technically. However, she did have to pay an $18 processing fee
per $100 that she borrowed.
If she were to consider the processing fee to represent interest paid in her formula, what would she discover to
be the annual interest rate she was charged on her short term loan?
Answers
Answer:
216%
Explanation:
Ordinary interest is computed on the basis of a 360-day year, so Marina's borrowing period is 1/12 of a year. The annual rate is then 12 times the rate Marina pays for 30 days:
12 × 18/100 = 216/100 = 216%
Marina would discover the annual interest rate is 216%.
Selma operates a contractor's supply store. She maintains her books using the cash method. At the end of the year, her accountant computes her accrual basis income that is used on her tax return. For 2015, Selma had cash receipts of $1.4 million, which included $200,000 collected on accounts receivable from 2014 sales. It also included the proceeds of a $100,000 bank loan. At the end of 2015, she had $250,000 in accounts receivale from customers, all from 2015 sales.
a. Compute Selma's accrual basis gross receipts for 2015
b. Selma paid cash for all of the purchases. The total amount paid for merchandise in 2014 was $1.3 million. At the end of 2014, she had merchandise on hand with a cost of $150,000. At the end of 2015, the cost of merchandise on hand was $300,000. Compute Selma's gross income from merchandise sales for 2015
Answers
Answer:
A.$1,350,000
B.$ 200,000
Explanation:
Selma
a.
Selma's accrual basis gross receipts for 2015 will be ;
Amount of Cash received by Selma $1,400,000
Less:
Accounts receivable collected (200,000)
Bank loan proceed(100,000)
Add: Ending accounts receivable 250,000
Gross receipts $1,350,000
b.Selma's gross income from merchandise sales for 2015 will be :
Gross receipts brought forward(A) $1,350,000
Cost of goods sold:
Selma Purchases$1,300,000
Inventory at the beginning 150,000
Ending inventory(300,000)
Gross income$ 200,000
(1,350,000-1,150,000)
(1,300,000+150,000-300,000)
=1,150,000
Markland Manufacturing intends to increase capacity by overcoming a bottleneck operation by adding new equipment. Two vendors have presented proposals. The fixed costs are $ 60 comma 000 for proposal A and $ 75 comma 000 for proposal B. The variable cost is $ 12.00 for A and $ 10.00 for B. The revenue generated by each unit is $ 22.00.
Required:
a. What is the break-even point in units for proposal A?
b. What is the break-even point in units for proposal B?
Answers
Answer:
Break-event point
Product A 6,000 units
Product B 6,250 units
Explanation:
The break-even point is the level of activity that a business must operate to equate total revenue to total cost . At the break even point, the business makes no profit or loss., and the total contribution is equal to total fixed cost
The break-even point is calculated as follows:
Total general fixed cost/(selling price - variable cost)
Break-even point = 60,000/(22-12)=6000 units
Product B
Beak-even point = 75,000/(22-10)=6250 units
Break-event point
Product A 6,000 units
Product B 6,250 units
Calculate the Social Security and Medicare deductions for the following employee (assume a tax rate of 6.2% on $128,400 for Social Security and 1.45% for Medicare): (Round your answers to the nearest cent.)
Answers
Answer:
Social Security tax = $7,960.80
Medicare tax = $1,861.80
Explanation:
Let's begin by listing out the information given:
Social Security tax rate = 6.2%,
Medicare tax rate = 1.45%,
Income = $128,400
To calculate for the deductions(tax), we use the formula:
Tax = Tax rate * Income
For Social Security
Tax = Tax rate * Income
Tax = 6.2% * $128,400
T = 0.062 * $128,400
T = $7,960.80
∴ $7,960.80 of the employee's income is deducted for Social Security tax
For Medicare
Tax = Tax rate * Income
Tax = 1.45% * $128,400
T = 0.0145 * $128,400
T = $1,861.80
∴ $1,861.80 of the employee's income is deducted for Medicare tax
Cane Company manufactures two products called Alpha and Beta that sell for $185 and $120, respectively. Each product uses only one type of raw material that costs $5 per pound. The company has the capacity to annually produce 112,000 units of each product. Its unit costs for each product at this level of activity are given below:
Alpha Beta
Direct materials $ 30 $ 10
Direct labor 22 29
Variable manufacturing overhead 20 13
Traceable fixed manufacturing overhead 24 26
Variable selling expenses 20 16
Common fixed expenses 23 18
Total cost per unit $ 139 $ 112
The company considers its traceable fixed manufacturing overhead to be avoidable, whereas its common fixed expenses are deemed unavoidable and have been allocated to products based on sales dollars.
Required:
7.
Assume that Cane normally produces and sells 48,000 Betas per year. If Cane discontinues the Beta product line, how much will profits increase or decrease?
8.
Assume that Cane normally produces and sells 68,000 Betas and 88,000 Alphas per year. If Cane discontinues the Beta product line, its sales representatives could increase sales of Alpha by 12,000 units. If Cane discontinues the Beta product line, how much would profits increase or decrease?
9.
Assume that Cane expects to produce and sell 88,000 Alphas during the current year. A supplier has offered to manufacture and deliver 88,000 Alphas to Cane for a price of $112 per unit. If Cane buys 88,000 units from the supplier instead of making those units, how much will profits increase or decrease?
10.
Assume that Cane expects to produce and sell 58,000 Alphas during the current year. A supplier has offered to manufacture and deliver 58,000 Alphas to Cane for a price of $112 per unit. If Cane buys 58,000 units from the supplier instead of making those units, how much will profits increase or decrease?
13.
Assume that Cane’s customers would buy a maximum of 88,000 units of Alpha and 68,000 units of Beta. Also assume that the company’s raw material available for production is limited to 172,000 pounds. How many units of each product should Cane produce to maximize its profits?
14.
Assume that Cane’s customers would buy a maximum of 88,000 units of Alpha and 68,000 units of Beta. Also assume that the company’s raw material available for production is limited to 172,000 pounds. What is the maximum contribution margin Cane Company can earn given the limited quantity of raw materials?
15.
Assume that Cane’s customers would buy a maximum of 88,000 units of Alpha and 68,000 units of Beta. Also assume that the company’s raw material available for production is limited to 172,000 pounds. Up to how much should it be willing to pay per pound for additional raw materials? (Round your answer to 2 decimal places.)
Answers
Answer:
7. profits will decrease by:
lost profits = total revenue - total costs = $5,760,000 - $5,376,000 = $384,000unavoidable fixed costs = $18 x 48,000 units = $864,000total decrease in profits ($1,248,000)8. profits will decrease by:
lost profits from Beta product line = $8,160,000 - $7,616,000 = ($544,000)increased profits from Alpha sales = $2,220,000 - $1,668,000 = $552,000unavoidable fixed costs = (68,000 x $18) - (12,000 x $23) = (948,000)total decrease in profits ($940,000)9. profits will increase by:
avoidable costs of producing 88,000 Alphas = 88,000 x $116 = $10,208,000cost of purchasing 88,000 x $112 = ($9,856,000)total increase in profits = $10,208,000 - $9,856,000 = $352,00010. profits will increase by:
avoidable costs of producing 58,000 Alphas = 58,000 x $116 = $6,728,000cost of purchasing 58,000 x $112 = ($6,496,000)total increase in profits = $6,728,000 - $6,496,000 = $232,00013. Since the profit margin per pound of direct materials used for Alphas = $7.67 and Betas = $4, the company should produce Alphas. It should produce 28,666 Alphas and 2 Betas. Total profits = $1,318,636 + $16 = $1,318,652
14. Maximum contribution margin:
Contribution margin Alphas = 28,666 units x $92 = $2,637,272Contribution margin Betas = 2 units x $52 = $104total contribution margin = $2,637,37615. Since the profit margin per pound of materials used Betas is only $4, there is not much room for increasing the materials costs. If you want to produce Betas, you would be willing to pay less than $9 per pound of direct materials.
But since the profit margin per pound of direct materials used on Alphas is much higher ($7.67), as long as you pay less than $12.97 per pound of direct materials you can still make a profit producing Alphas. So you could pay a much higher price if you wanted to produce Alphas and still make a profit.
Explanation:
Alpha Beta
Sales price $185 $120
Direct materials ($5 per pound) $30 $10
pounds of materials used 6 2
profit margin per pound $7.67 $4
Direct labor $22 $29
Variable manufacturing overhead $20 $13
Traceable fixed man. overhead $24 $26
Variable selling expenses $20 $16
Common fixed expenses (unavoidable) $23 $18
Total cost per unit $139 $112
total production capacity 112,000 units per year
contribution margin = sales revenue - variable costs:
contribution margin Alpha = $185 - $93 = $92
contribution margin Beta = $120 - $68 = $52
Gretchen has just started as a fashion marketing intern for an up-and-coming design firm. When she came in, she was asked to work on a project identifying important events where celebrities might wear the fashions. She soon realized that this activity was part of _____________, directly related to marketing.
Answers
Answer:
A push-pull strategy
Explanation:
The Push strategy is an aspect of marketing where the marketer aims at taking his products directly to a target audience. This is done so as to stimulate the interest of the consumer in that particular product. Developing brands tend to employ this strategy to showcase themselves to the consumer in hopes of getting them attracted to their products. This is the strategy which the up-and-coming design firm is trying to employ when they seek to identify important events where celebrities might wear the fashions. They engage in this activity because they want to showcase their designs to the target audience- the celebrities.
Pull strategy is the opposite of this strategy as customers are now aware of the reputation of the brand and then seek them out on their own.
Why is research ethics important?
Answers
Answer:
Research ethics are important for the following reasons:
1.They promote the aims of research, such as expanding knowledge.
2.They support the values required for collaborative work
3. They support important social and moral values,
Roadside, Inc. had the following balances and transactions during 2018:Beginning Merchandise Inventory10units at $ 72March 10Sold 8unitsJune 10Purchased 20units at $ 82October 30Sold 14unitsWhat is the amount of the company's ending Merchandise Inventory, as disclosed in the December 31, 2018 balance sheet, using the periodic LIFO inventory costing method?
Answers
Answer:
$576
Explanation:
The computation of the ending inventory using the periodic LIFO inventory costing method is shown below:
But before determining the ending inventory first we have to find out the ending inventory units which is
Units of ending inventory = Opening Stock + Units purchased - Units sold
= 10 + 20 - (8 + 14)
= 8 units
The Ending inventory is 8 units. So, These should be the units out of opening stock
Therefore
Ending inventory is
= 8 units × $72
= $576
Section 103 of the Federal Public Works Employment Act establishes the Minority Business Enterprise program and requires that, absent a waiver by the secretary of commerce, 10 percent of all federal grants given by the Economic Development Administration be used to purchase services or supplies from businesses owned and controlled by U.S. citizens belonging to one of six minority groups: African Americans, Spanish speaking, Asian, Native American, Eskimo, and Aleut. White owners of business contend the Act constitutes illegal reverse discrimination. Discuss.
Answers
Explanation:
Looking from a fair point of view, the White owners of businesses have legitimate reasons to feel that the Act constitutes illegal reverse discrimination.
Remember, reverse discrimination implies an unfair treatment of the majority group (White owners) in an effort to please the minority group. This is evident from the fact that the 10 percent of all federal grants to be released by the Economic Development Administration was only to be used to purchase services or supplies from businesses owned and controlled by U.S. citizens belonging to one of six minority groups excluding the White business owners; making the White owners feel discriminated against.
Thus, unintentionally the Act became a reverse discrimination on White business owners.
Miguel works at LoftCo, Inc., and has been asked to help lead the development of the company's new balanced scorecard. He and his multifunctional team developed strategic objectives and performance metrics for each of the four perspectives. This work constitutes the complete set of steps in developing a BSC performance management system.
a. true
b. false
Answers
Answer:
The correct answer is A. True
Explanation:
Solution
Balanced scorecard performance management system: It is define as a management system and strategic planning that companies or firms use in communicating their set target and objectives.
Furthermore, a balanced scorecard is a measurement of management performance which can recognize and refine internal functions and external results.
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March.
Date Activiies Units Acquired at Cost Units Sold at Recall
Mar. 1 Beginning inventory 60 units $50.20 per unit
Mar. 5 Purchase 205 units $55.20 per unit
Mar. 9 Sales 220 units $85.20 per unit
Mar. 18 Purchase 65 units $60.20 per unit
Mar. 25 Purchase 110 units $62.20 per unit
Mar. 29 Sales 90 units $95.20 units
Total 440 units 310 units
Required:
1. Compute cost of goods available for sale and the number of units available for sale.
2. Compute the number of units in ending inventory.
3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. For specific identification, units sold consist of 600 units from beginning inventory, 300 from the February 10 purchase, 200 from the March 13 purchase, 50 from the August 21 purchase, and 250 from the September 5 purchase.
4. Compute gross profit earned by the company for each of the four costing methods.
Answers
Answer:
Warnerwoods Company
Perpetual Inventory System:
1. Cost of Goods Available for Sale and Units Available for Sale:
Mar. 1 Beginning inventory 60 units $50.20 per unit $3,012
Mar. 5 Purchase 205 units $55.20 per unit 11,316
Mar. 18 Purchase 65 units $60.20 per unit 3,913
Mar. 25 Purchase 110 units $62.20 per unit 6,842
Available for Sale 440 units Cost = $25,083
2. The number of units in ending inventory:
Units Available for Sale 440
Subtract units sold 310
Ending Inventory 130 units
3. The Cost assigned to ending inventory using:
a) FIFO: Ending Inventory
20 units at $60.20 per unit = $1,204
110 units at $62.20 per unit = 6,842
Ending Inventory $8,046
b) LIFO: Ending Inventory
Mar. 1 Beginning Inventory 45 units $50.20 per unit = $2,259
Mar. 18 Purchase 65 units $60.20 per unit = 3,913
Mar. 25 Purchase 20 units $62.20 per unit = 1,244
Ending Inventory 130 units Cost = $7,416
c) Weighted Average: Ending Inventory
Cost of Goods Available for Sale divided by units available for sale
= $25,083/440 = $57 per unit
Ending Inventory = $57 x 130 = $7,410
d) Specific Identification: Ending Inventory
This cannot be answered from the information provided in the question:
4. Gross Profit for each costing method:
FIFO LIFO WEIGHTED SPECIFIC
AVERAGE IDENTIFICATION
Sales $27,312 $27,312 $27,312 $27,312
Cost of Sales 17,037 17,667 17,670
Gross Profit $10,275 $9,645 $9,642
Explanation:
a) Sales:
Mar. 9 Sales 220 units $85.20 per unit = $18,744
Mar. 29 Sales 90 units $95.20 units = 8,568
Total = $27,312
b) Cost of Sales:
i) FIFO
Mar 1. Beginning inventory 60 units $50.20 per unit = $3,012
Mar. 5 Purchase 205 units $55.20 per unit = 11,316
Mar. 18 Purchase 45 units $60.20 = 2,709
Cost of Sales = $17,037
ii) LIFO:
Mar. 1 Beginning inventory 15 units $50.20 per unit = $753
Mar. 5 Purchase 205 units $55.20 per unit = $11,316
Mar. 25 Purchase 90 units $62.20 per unit = $5,598
Cost of Sales = $17,667
iii) Weighted Average:
Cost of Sales = $57 x 310 = $17,670
c) Calculations under the specific identification cannot be made because of the figures given under this method.
Cost of goods available for sale = 440 units and $25,071
Number of units in ending inventory is 130 units.
1. The calculation of compute cost of goods available for sale and the number of units available for sale is;
Beginning inventory cost = 60 units x $50.20 = $3,012Purchase on March 5 cost = 205 units x $55.20 = $11,304Purchase on March 18 cost = 65 units x $60.20 = $3,913Purchase on March 25 cost = 110 units x $62.20 = $6,842Cost of goods available for sale = 440 units and $25,071
2. Number of units in ending inventory:
Units sold = 220 + 90 Units sold = 310 unitsUnits in ending inventory = total available for sale - units sold Units in ending inventory = 440 - 310 = 130 unitsNumber of units in ending inventory is 130 units.
3. Compute the cost assigned to ending inventory
4. Compute gross profit earned by the company for each of the four costing methods.
Learn more about on inventory, here:
https://brainly.com/question/31146932
#SPJ6
Esquire Comic Book Company had income before tax of $1,000,000 in 2016 before considering the following material items:
1. Esquire sold one of its operating divisions, which qualified as a separate component according to generally accepted accounting principles. The before-tax loss on disposal was $350,000. The division generated beforetax income from operations from the beginning of the year through disposal of $500,000. Neither the loss on disposal nor the operating income is included in the $1,000,000 before-tax income the company generated from its other divisions.
2. The company incurred restructuring costs of $80,000 during the year.
Required: Prepare a 2016 income statement for Esquire beginning with income from continuing operations. Assume an income tax rate of 40%. Ignore EPS disclosures.
Answers
Answer:
Esquire Comic Book Company
Income Statement
For the Year Ended December 31, 2016
Operating income $1,000,000
Restructuring costs ($80,000)
Income from continuing operations b/ Taxes $920,000
Income tax expense ($368,000)
Income from continuing operations $552,000
Discontinued operations:
Operating income $500,000Loss on disposal ($350,000)Income tax on discontinued operations ($60,000)Income from discontinued operations $90,000
Net income $642,000
Explanation:
Income from discontinued operations must be reported separately, but any restructuring costs must be included as operational expenses.
Journalize the following transactions using the direct write-off method of accounting for uncollectible receivables: Feb. 20 Received $1,000 from Andrew Warren and wrote off the remainder owed of $4,000 as uncollectible. May 10 Reinstated the account of Andrew Warren and received $4,000 cash in full payment. If an amount box does not require an entry, leave it blank. Feb. 20 May 10 May 10
Answers
Answer:
A journal was entered to determine the following transactions using the direct write-off method of accounting for uncollectible receivable shown below
Explanation:
Solution
PART A:
Particulars Debit Credit
Feb 20 Bad Debt Expense $4,000
Cash $1,000
Accounts receivable $5000
May 10 Accounts receivable $4,000
Bad Debt Expense $4,000
Cash $4,000
Accounts receivable $4,000
Rank the following instruments in terms of credit risk. In your rankings, use 1 for the greatest credit risk and 4 for the smallest credit risk. Assume a 10 year Treasury trades with a YTM of 5%.a. A Ba1 corporate bond ______b. A ten-year BBB- corporate bond with a YTM of 7% ______c. A secured loan from Argosy Gaming, which is a B- rated firm ______d. A senior subordinated bond from Argosy Gaming
Answers
Answer:
a. A Ba1 corporate bond 2 (not investment grade)
b. A ten-year BBB- corporate bond with a YTM of 7% 3 (medium risk but still investment grade)
c. A secured loan from Argosy Gaming, which is a B- rated firm 4 (less risky since it is backed by a collateral)
d. A senior subordinated bond from Argosy Gaming 1 (highest risk)
Explanation:
There are two major bond rating agencies in the US: Moody's and Standard & Poor's.
Their rankings are very similar, although the letters vary a little:
AAA: safest
AA: low risk
A: low risk
BBB: medium risk
BB: a little bit more riskier
B: risky
CCC: very high risk
CC: even riskier
C: riskiest
D: junk, in default
On July 8, Jones Inc. issued an $62,900, 9%, 120-day note payable to Miller Company. Assume that the fiscal year of Jones ends on July 31. Using the 360-day year, what is the amount of interest expense recognized by Jones in the current fiscal year
Answers
Answer:
The amount of interest expense recognized by Jones in the current fiscal year is $361.675
Explanation:
According to the given data Jones Inc. issued an $62,900, 9%, 120-day note payable to Miller Company On July 8, therefore if the the fiscal year of Jones ends on July 31 there 23 days between July 8 and July 31.
So, to calculate the amount of interest expense recognized by Jones in the current fiscal year we would have to make the following calculation:
Interest expense=$62,900*9%*(23/360)
Interest expense=$361.675
The amount of interest expense recognized by Jones in the current fiscal year is $361.675
The common stock of Buildwell Conservation & Construction Inc. (BCCI) has a beta of .9. The Treasury bill rate is 4%, and the market risk premium is estimated at 8%. BCCI’s capital structure is 30% debt, paying an interest rate of 5%, and 70% equity. The debt sells at par. Buildwell pays tax at 40%.
a. What is BCCI’s cost of equity capital? (Do not round intermediate calculations. Enter your answer as a percent rounded to 1 decimal place.)
Cost of equity capital %
b. What is its WACC? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)
WACC %
Answers
Answer:
Cost of equity is 11.2%
WACC is 8.74%
Explanation:
The formula for cost of equity is given below:
Cost of equity=risk free rate+(Beta *risk premium)
risk free rate is the treasury bill rate of 4%
Beta is 0.9
market risk premium is 8%
cost of equity=4%+(0.9*8%)=11.2%
WACC=Ke*E/V+Kd*D/V*(1-t)
Ke is the cost of equity of 11.2%
Kd is the cost of debt of 5%
t is the tax rate of 40% or 0.4
E is the equity weighting of 70% or 0.7
D is the debt weighting of 30% or 0.3
V is the E+D=0.7+0.3=1
WACC=11.20% *0.7/1+(5%*0.3/1*(1-0.4)
WACC=7.84% +0.90% =8.74%
Digital Corp is considering investing in project A. Their accountants gave them the following information: Initial investment: $1,200,000 Salvage Value: $340,000 Contribution Margin: $320,000 Present Value of Cash Flows: 4,580,000 Annual Cash Inflow: $850,000 Cost of Capital: 9% Length of project: 5 years What is the payback period
Answers
Answer:
The payback period for the investment is 1.41 years
Explanation:
The payback period is the length of time it takes an investment to repay back the investment capital outlay committed to it at the inception of the project.
The payback period is computed as the initial investment divided by annual cash inflow
Initial investment is $1,200,000
Annual cash inflow is $850,000
Payback period=$1,200,000/$850,000= 1.41 years
We can express the 0.41 in months=0.41*12=4.92 approximately 5 months
A local radio commercial costs $600 and reaches an estimated 10,250 listeners. A local cable commercial costs $1000 and reaches an estimated 18,500 viewers. Which medium provides the lowest CPM?
a. The radio commercial
b. The cable commercial
c. The radio and cable commercials have the same CPM
d. The CPM cannot be calculated given the limited information provided
e. None of the above
Answers
Answer:
b. The cable commercial
Explanation:
CPM or cost per mille is a measure used in advertising to determine how effectively a promotional message is getting to its audience. It is the cost of getting an advert in front of 1,000 people.
In this scenario when we calculate CPM for the radio station
$600 = 10,250 listeners
x= 1,000 listeners
Cross multiply
x= (600 * 1,000) ÷ 10,250 = $58.54
For the local cable commercial
$1000 = 18,500 viewers
y = 1,000 viewers
Cross multiply
y= (1,000 * 1,000) ÷ 18,500= $54.05
You are looking to buy a car. You can afford $700 in monthly payments for five years. In addition to the loan, you can make a $800 down payment. If interest rates are 9.25 percent APR, what price of car can you afford (loan plus down payment)
Answers
Answer:
$34,333
Explanation:
A fix periodic payment for a specific period of time is an annuity payment. Price of the car can be determined by the sum of the present value of all payments and down payment made.
First we need o calculate the present value of annuity using following formula
Present value of annuity = P x [ 1 - ( 1 + r )^-n / r ]
P = periodic payment = $700
r = APR = 9.25 /12% = 0.77%
n = numbers of periods = 5 years x 12 months per year = 60 months
Placing values in the formula
Present value of annuity = $700 x [ 1 - ( 1 + 0.77% )^-60 / 0.77% ]
Present value of annuity = $33,532.88
Price of the car = Present value of annuity + Down Payment
Price of the car = $33,532.88 + $800 = $34,332.88
(5). The variance of Stock A is .005, the variance of the market is .008 and the covariance between the two is .0026. What is the correlation coefficient
Answers
Answer:
0.4110
Explanation:
The formula and computation of the correlation coefficient is shown below:
Correlation co-efficient = Covariance ÷ (Standard deviation of market × Standard deviation of Stock A)
where,
Covariance between the two = 0.0026
Variance of the stock A = 0.005
And, the variance of the market is 0.008
Now placing these values to the above formula
So, the correlation coefficient is
= 0.0026 ÷ (0.008 × 0.005)^0.50
= 0.0026 ÷ 0.006324555
= 0.411096096
= 0.4110
Hence, the correlation coefficient is 0.4110
The law of diminishing marginal productivity states that:________.
a. As you expand output, your marginal productivity eventually increases
b. As you expand output, your marginal productivity eventually declines
c. As you expand output, the total product eventually increases
d. None of the above
2. What are economies of scale?
a. decreasing average costs as production increases
b. increasing average costs as production increases
c. increasing fixed costs as production increases
d. none of the above
3. What are economies of scope?
a. lower average costs when multiple different products are produced
b. higher average costs when multiple different products are produced
c. Constant average costs when multiple different products are produced
d. none of the above
Answers
Answer:
b. As you expand output, your marginal productivity eventually declines
a. decreasing average costs as production increases
a. lower average costs when multiple different products are produced
Explanation:
The law of diminishing marginal returns states that as more unit of variable factors of production are added to production, output would increase at first but after a period, it would increase at a negative rate.
Economies of scale is the reduction in cost thay accrue to firms as they increase production. For example, a supplier might give a firm a discount for buying in bulk.
Economies of scope states that average cost would fall as the production of similar products increases. For example, a fashion designer who makes women's clothings decides to make scarfs with the scraps of clothes left.
I hope my answer helps you
Mila is helping to set performance targets for her company, Urban Supply. The target of increasing the company's online customer satisfaction rate by 1% in the next quarter is an example of a performance target focused on the customer perspective of the balance scorecard.
a. true
b. false
Answers
Answer: True
Explanation:
The balanced scorecard perspective implies that the company has to satisfy their customer through the provision of quality products and services.
From the question, the target of increasing customers satisfaction is a good example of a performance target that is focused on customer's perspective of the balance scorecard. This means that the statement is true.
Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million shares outstanding and a target capital structure consisting of 30% debt; its beta is 1.10 (given its target capital structure). Vandell has $8.67 million in debt that trades at par and pays an 7.3% interest rate. Vandell’s free cash flow (FCF0) is $1 million per year and is expected to grow at a constant rate of 6% a year. Both Vandell and Hastings pay a 40% combined federal and state tax rate. The risk-free rate of interest is 6% and the market risk premium is 7%. Hastings Corporation estimates that if it acquires Vandell Corporation, synergies will cause Vandell’s free cash flows to be $2.5 million, $3.2 million, $3.5 million, and $3.57 million at Years 1 through 4, respectively, after which the free cash flows will grow at a constant 6% rate. Hastings plans to assume Vandell’s $8.67 million in debt (which has an 7.3% interest rate) and raise additional debt financing at the time of the acquisition. Hastings estimates that interest payments will be $1.5 million each year for Years 1, 2, and 3. After Year 3, a target capital structure of 30% debt will be maintained. Interest at Year 4 will be $1.465 million, after which the interest and the tax shield will grow at 6%. Indicate the range of possible prices that Hastings could bid for each share of Vandell common stock in an acquisition. Round your answers to the nearest cent. Do not round intermediate calculations.
The bid for each share should range between $ ______ per share and $ _______ per share.
Answers
Answer:
$40.79 per share and $52.90 per share
Explanation:
Cost of Debt (Kd) = Wd * Rd (1 - T)
Cost of Debt for Vandell Corporation is $7.30 * (1 - 0.40) = 4.38%
Cost of Equity (Ke) = Rf + [tex]\beta[/tex] * Rp
Cost of Equity for Vandell Corporation is 6 + 1.10 * 7 = 13.70%
Weighted Average Cost of Capital (WACC) = Wd * Kd + We * Ke
Cash Flow of Firm = $2.5m + $3.2m + $3.5m + $3.57m = $12.77
Weight of Equity = $8.94
WACC = 30% * 4.38% + 70% * 13.70% = 10.9%
CashFlows after discounting synergy will be = $40.79
Digger Inc. sells a high-speed retrieval system for mining information. It provides the following information for the year.
Budgeted Actual
Overhead cost $975,000 $950,000
Machine hours 50,000 45,000
Direct labor hours 100,000 92,000
Required:
a. Compute the predetermined overhead rate.
b. Determine the amount of overhead applied for the year.
Answers
Answer:
Predetermined overhead rate = $ 9.75 per direct labor hours
Overhead applied = $897,000
Explanation:
Given:
Budgeted Overhead cost = $975,000
Actual Overhead cost = $950,000
Budgeted Machine hours = 50,000
Actual Machine hours = 45,000
Budgeted Direct labor hours = 100,000
Actual Direct labor hours = 92,000
Computation:
(a) Predetermined overhead rate.
Predetermined overhead rate = budgeted overhead cost / budgeted direct labor hours
Predetermined overhead rate = $975,000 / 100,000
Predetermined overhead rate = $ 9.75 per direct labor hours
(b) Amount of overhead applied for the year.
Overhead applied = Actual hours × Predetermined overhead rate
Overhead applied = 92000 × $9.75
Overhead applied = $897,000
The following comparative income statement (in thousands of dollars) for the two recent fiscal years was adapted from the annual report of Speedway Motorsports, Inc., owner and operator of several major motor speedways, such as the Atlanta, Texas, and Las Vegas Motor Speedways.
1 Current Year Previous Year
2 Revenues:
3 Admissions $116,034.00 $130,239.00
4 Event-related revenue 151,562.00 163,621.00
5 NASCAR broadcasting revenue 192,662.00 185,394.00
6 Other operating revenue 29,902.00 26,951.00
7 Total revenue $490,160.00 $506,205.00
8 Expenses and other:
9 Direct expense of events $101,402.00 $106,204.00
10 NASCAR purse and sanction fees 122,950.00 120,146.00
11Other direct expenses 18,908.00 20,352.00
12 General and administrative 183,215.00 241,223.00
13 Total expenses and other $426,475.00 $487,925.00
14 Income from continuing operations $63,685.00 $18,280.00
Required:
A. Prepare a comparative income statement for these two years in vertical form, stating each item as a percent of revenues. Enter all amounts as positive numbers. Rounding instructions
B. Comment on the significant changes.
Prepare a comparative income statement for these two years in vertical form, stating each item as a percent of revenues. Enter all amounts as positive numbers. Rounding instructions
Answers
Answer:
A)
Speedway Motorsports, Inc.
Comparative Income statement
For the Years 202x and 202x₋₁
202x 202x₋₁
Total revenue $490,160 $506,205
Admissions 23.67% 25.73%Event related 30.92% 32.32%NASCAR broadcasting 39.31% 36.63%Other operating revenue 6.1% 5.32%Direct expenses: 49.63% 48.74%
Direct expense of events 20.69% 20.98% NASCAR purse & sanction fees 25.08% 23.73%Other direct expenses 3.86% 4.03%General and administrative 37.38% 47.65%
Income from continuing operations 12.99% 3.61%
B) The most significant changes are that total revenues actually decreased, but net income from operating activities actually creased both in $ amounts and as % of total revenue. Direct expenses remained at similar levels during both years, even 202x₋₁ direct expenses were lower. But the most significant cost reduction was made on general and administrative expenses which were lowered by almost 10% (compared to total revenues). Only NASCAR broadcasting related revenues increased, while all the other revenues decreased in % and absolute amounts.
Barbara owns a manufacturing plant with four facilities (North, South, East, and West) in the state of Indiana. The workers at one of those facilities, North, have just decided to join a union. The union negotiates with Barbara and receives average wages that are 5% higher than the workers at the South, East, and West facilities. This wage differential is a likely example of:
Answers
Answer:
Union power
Explanation:
The difference in wages is as a result of Union power because the North now belongs to a labor union that protects their interest. A labor union is an organization that plays the role of an intermediary between their members and their employers. The workers in the North through the union are able to negotiate for better wages. Through collective bargaining, the union gives workers In the North the power to request for better work pay than workers in the east, West and South facilities.
Imperial Jewelers manufactures and sells a gold bracelet for $408.00. The company’s accounting system says that the unit product cost for this bracelet is $268.00 as shown below:
Direct materials $147
Direct labor 85
Manufacturing overhead 36
Unit product cost $268
The members of a wedding party have approached Imperial Jewelers about buying 30 of these gold bracelets for the discounted price of $368.00 each. The members of the wedding party would like special filigree applied to the bracelets that would require Imperial Jewelers to buy a special tool for $452 and that would increase the direct materials cost per bracelet by $9. The special tool would have no other use once the special order is completed.
To analyze this special order opportunity, Imperial Jewelers has determined that most of its manufacturing overhead is fixed and unaffected by variations in how much jewelry is produced in any given period. However, $15.00 of the overhead is variable with respect to the number of bracelets produced. The company also believes that accepting this order would have no effect on its ability to produce and sell jewelry to other customers. Furthermore, the company could fulfill the wedding party’s order using its existing manufacturing capacity.
Required:
a. What is the financial advantage (disadvantage) of accepting the special order from the wedding party?
b Should the company accept the special order?
Answers
Answer:
2352, Yes
Explanation:
a) Incremental Cost = Direct Material cost + Direct labour cost + Filgree + Manufacturing overhead cost
= 147 + 85 + 9 + 15 = 256
Total additional Cost = 256 x 21 = 5376
Incremental Revenue = 368
Total additional Revenue = 368 x 21 = 7728
Incremental net operating income = Total additional revenue - total additional cost
= 7728 - 5376 = 2352
b) As Incremental net operating income is positive, company is earning from the special order. Yes, it should accept it
The relevant costs for a decision to accept the special order are :
1. Incremental Revenue from the special order
2. incremental variable cost
3. The cost of the special tool
Unit variable cost = 147+ 85 + 9 + 15 = $256
The balance of manufacturing overhead would be incurred either way. Therefore, they are not relevant for the decision
Sales revenue from special order $
(21× $368) 7728
The Variable cost of special order $
(21× $256) (5376 )
Financial advantage 2358
The company should accept the special order, as it will increase its profit by $2352
Know more:
https://brainly.com/question/16251128?referrer=searchResults
Use the following 10% interest factors. Present Value of Ordinary Annuity Future Value of Ordinary Annuity 7 periods 4.86842 9.48717 8 periods 5.33493 11.43589 9 periods 5.75902 13.57948 What amount should be recorded as the cost of a machine purchased December 31, 2020, which is to be financed by making 8 annual payments of $16000 each beginning December 31, 2021? The applicable interest rate is 10%. $182974 $92144 $85359 $112000
Answers
Answer:
The cost of the machine will be $85,358.88
Explanation:
To calculate the present value of the machine is given by:
Present value=$16000*Present value of annuity factor(10%,8)
=$16000*5.33493
= $85,358.88
Hardwig Inc. is considering whether to pursue a restricted or relaxed current asset investment policy. The firm's annual sales are expected to total $3,600,000, its fixed assets turnover ratio equals 4.0, and its debt and common equity are each 50% of total assets. EBIT is $150,000, the interest rate on the firm's debt is 10%, and the tax rate is 40%. If the company follows a restricted policy, its total assets turnover will be 2.5. Under a relaxed policy its total assets turnover will be 2.2. Refer to the data for Hardwig, Inc. Assume now that the company believes that if it adopts a restricted policy, its sales will fall by 15% and EBIT will fall by 10%, but its total assets turnover, debt ratio, interest rate, and tax rate will all remain the same. In this situation, what's the difference between the projected ROEs under the restricted and relaxed policies? a. 2.46% b. 2.98% c. 3.27% d. 2.24% e. 2.70%
Answers
Answer:
d. 2.24%
Explanation:
total annual sales = $3,600,000
fixed asset turnover = total sales / fixed assets = 4, that means that total fixed assets = $3,600,000 / 4 = $900,000
debt = 50% = $450,000
equity = 50% = $450,000
EBIT = $150,000
net income = $150,000 x (1 - 40%) = $90,000
restricted policy:
asset turnover = 2.5
sales = $3,600,000 x (1 - 15%) = $3,060,000
EBIT = $135,000
net income = $81,000
assets = $3,060,000 / 2.5 = $1,224,000
equity = $1,224,000 x 50% = $612,000
ROE = $81,000 / $612,000 = 13.24%
relaxed policy:
asset turnover = 2.2
EBIT = $150,000
net income = $90,000
assets = $3,600,000 / 2.2 = $1,636,364
equity = 50% x $1,636,364 = $818,182
ROE = $90,000 / $818,182 = 11%
difference between ROEs = 13.24% - 11% = 2.24%
Torino Company has 1,300 shares of $50 par value, 6.0% cumulative and nonparticipating preferred stock and 13,000 shares of $10 par value common stock outstanding. The company paid total cash dividends of $3,500 in its first year of operation. The cash dividend that must be paid to preferred stockholders in the second year before any dividend is paid to common stockholders is:
Answers
Answer:
The answer is $4,300
Explanation:
Solution
We recall that:
Torino company has 1,200 shares of = $50 per value
The cumulative and nonparticipating preferred stock of = 6.0%
They also have 13,00 shares
Common stock outstanding = $10 per value
Total dividends = $3,500
Now,
The first year amount of dividend that was paid in the first year of working is stated as follows:
6% * 1300 * 50 = $3900
The paid dividend = $3,500
The amount amount payable during the second year to the common stakeholders is
=$3900 + 400 = $4,300
Note: preferred shares are cumulative, for this the amount paid to the stakeholders was $4,300
