Spelling Company has the following sales projection (in units)
for the next six months:
Feb: 9000
Mar: 10500
Apr: 8000
May: 11500
Jun: 9500
Jul: 7000
Each unit sells for $30.
Spelling has prepared the following sales budget for the quarter of
April, May and June:
| Sales Budget | ||||
| April | May | June | Total | |
| Sales in units | 8000 | 11500 | 9500 | 29000 |
| Selling price per unit | x $30 | x $30 | x $30 | |
| Sales revenue | $240000 | $345000 | $285000 | $870000 |
Spelling's cost of goods sold is 60% of its sales
revenue. The company has a policy that it keeps
10% of next months budgeted cost of goods sold as
ending inventory. The company had exactly the budgeted amount of
inventory on hand at April 1.
Prepare a purchases budget on paper or, PREFERABLY, in Excel for
the quarter of April, May and June. (If you build your schedule
using formulas in excel, multiple attempts will be much
faster.)
1. What is the cost of inventory at April 1 (Beginning
inventory)
2. What is the budgeted cost of purchases in
June?
3. What is the desired cost of inventory at the end of the
quarter?
In: Accounting
You are one of the three partners in RSM, an auditing firm. This year, RSM was engaged to audit year-end accounts and tax returns of a new and fast-growing engineering consulting company, CPEC. The business had started operations with only a few staff but now it has employees of over 100, still remaining below the size of a company which will require a compulsory audit by the government. During the course of the audit, you have discovered a significant increase in revenue this year compared to last year. Accordingly, your team investigated the increase and discovered a practice which your team believes is not in accordance with the financial reporting framework. Your team found out that one of the owners, who is also the managing director of CPEC, was doing consultancy services to some of his close friends. In effect, consultancy fees for these close friends were recorded as income of the company but not collected. They remain as collectibles of the company in the last five years and the company seem not to have any intention of collecting them. The accountant also have not written them off from the list of bad debts. This practice is also known to the other directors of the company. You have suspicions that this is done to increase the amount of revenue reported in the financial statements. Required: Explain your answer to the following questions: 1. Which fundamental ethical principles in ISA 200 will be affected in this scenario? You can explain more than one ethical principle, if applicable. 2. Is the practice dishonest? Explain your opinion. 3. Explain the impact of this scenario to your firm. 4. What could be the possible course of action?
In: Accounting
Yahoo Gold Mining Company (YGMC) mines coal, puts it through a
one-step crushing process, and loads the bulk raw coal onto river
barges for shipment to customers.
YGMC’s management is currently evaluating the possibility of
further processing the raw coal by sizing and cleaning it and
selling it to an expanded set of customers at higher prices. The
option of building a new sizing and cleaning plant is ruled out as
being financially infeasible. Instead, Darrell Cornwall, a mining
engineer, is asked to explore outside contracting arrangements for
the cleaning and sizing process.
Darrell puts together the following summary:
Selling price of raw coal = $27 per tonne
Cost of producing raw coal = $22 per tonne
Selling price of sized and cleaned coal = $36 per tonne
Annual raw coal output = 10,000,000 tonnes
Percentage of material weight loss in sizing/cleaning coal = 6%
Incremental Costs of Sizing and Cleaning Processes
Direct labour = $800,000 per year
Supervisory personnel = 200,000 per year
Heavy equipment: rental, operating, maintenance costs = 25,000 per
month
Contract sizing and cleaning = 3.50 per tonne of raw coal
Outbound rail freight = 240 per 60-tonne rail car
Darrell also learns that 75% of the material loss that occurs in
the cleaning and sizing process can be salvaged as coal fines,
which can be sold to steel manufacturers for their furnaces. The
sale of coal fines is erratic and YGMC may need to stockpile it in
a protected area for up to one year. The selling price of coal
fines ranges from $15 to $24 per tonne and costs of preparing coal
fines for sale range from $2 to $4 per tonne.
Required
1) Prepare an analysis to show whether it is more profitable for
YGMC to continue selling raw bulk coal or to process it further
through sizing and cleaning. (Ignore coal fines in your
analysis.)
2) How would your analysis be affected if the cost of producing raw
coal could be held down to $20 per tonne?
3) Now consider the potential value of the coal fines and prepare
an addendum that shows how their value affects the results of your
analysis prepared in requirement 1.
In: Accounting
Read about a number of health care delivery systems throughout the world. Using research with three evidence-based, peer-reviewed resources. IN A 3-4 PAGE PAPER,CHOOSE ONE COUNTRY (EXCLUDING UNITED STATES OF AMERICA) AND ANSWER THE QUESTIONS THAT FOLLOW.
PLEASE INCLUDE INTEXT CITATIONS AS WELL AS REFERENCE LIST
In: Nursing
1/ Hicks Health Clubs, Inc., expects to generate an annual EBIT of $506,000 and needs to obtain financing for $1,090,000 of assets. Their tax bracket is 32%. If the firm goes with a short-term financing plan, their rate will be 7.0 percent, and with a long-term financing plan their rate will be 8.0 percent. By how much will their earnings after tax change if they choose the more aggressive financing plan instead of the more conservative? (Amounts in parentheses indicate negative value.)
($7,412)
$7,412
($10,412)
$10,412
2/ Price Corp. is considering selling to a group of new customers and creating new annual sales of $420,000. 3% will be uncollectible. The collection cost on these accounts is 5% of new sales, the cost of producing and selling is 84% of sales and the firm is in the 32% tax bracket. What is the profit on new sales?
$352,800
$29,966
$32,848
$22,848
3/ Modos Company has deposited $4,190 in checks received from customers. It has written $1,530 in checks to its suppliers. The initial bank and book balance was $490. If $3,530 of its customer's checks have cleared but only $490 of its own, calculate its float.
$380
$1,150
$480
$530
In: Accounting
In: Accounting
American Surety and Fidelity buys and sells securities expecting
to earn profits on short-term differences in price. For the first
11 months of 2018, gains from selling trading securities totaled $6
million, losses were $12 million, and the company had earned $5
million in investment revenue. The following selected transactions
relate to American's trading account and equity securities
investment account during December 2018, and the first week of
2019. The company's fiscal year ends on December 31. No trading
securities were held by American on December 1, 2018.
| 2018 | ||||
| Dec. | 12 | Purchased FF&G Corporation bonds for $23 million. | ||
| 13 | Purchased 2 million Ferry Intercommunications common shares for $30 million. | |||
| 15 | Sold the FF&G Corporation bonds for $23.2 million. | |||
| 22 | Purchased U.S. Treasury bills for $70 million and Treasury bonds for $76 million. | |||
| 23 | Sold half the Ferry Intercommunications common shares for $10 million. | |||
| 26 | Sold the U.S. Treasury bills for $75 million. | |||
| 27 | Sold the Treasury bonds for $73 million. | |||
| 28 | Received cash dividends of $200,000 from the Ferry Intercommunications common shares. | |||
| 31 | Recorded any necessary adjusting entry(s) and closing entries relating to the investments. The market price of the Ferry Intercommunications stock was $10 per share. |
| 2019 | ||||
| Jan. | 2 | Sold the remaining Ferry Intercommunications common shares for $10.1 million. | ||
| 5 | Purchased Warehouse Designs Corporation bonds for $45 million. |
Required:
1. Prepare the appropriate journal entry for each
transaction or event during 2018.
2. Indicate any amounts that American would report
in its 2018 balance sheet and income statement as a result of these
investments.
3. Prepare the appropriate journal entry for each
transaction or event during 2019.
2***
| Balance Sheet | |
| Equity Investments | |
| Less: Fair Value Adjustment | |
| Total | |
| Income Statement: | |
| Investment Revenue | |
| Gain on Sale of Investments | |
| Loss on Sale of Investments | |
| Net unrealized holding gains and losses investment held | |
JE accounts.
In: Accounting
FX, Inc. is a volume manufacturer of high technology automotive mirrors (including cell link and voice activation). FX is looking to expand their operations to add a second product line capable of producing 1.3 Million units per year. The equipment investment cost for this new operation is $27 Million. The project falls under a 7 year MACRS class life and the company estimates that the salvage value will be $2.7 Million at the end of the 6 year project. The average selling price for each mirror is $85 per unit. The annual expected sales shown below:
|
Year |
2020 |
2021 |
2022 |
2023 |
2024 |
2025 |
|
Volume (000) |
600 |
750 |
1000 |
1200 |
1200 |
1200 |
The material cost for each mirror is $20 (with 25 % of the material imported from Canada and 35% from Mexico). The labor to produce each mirror is $15 with additional variable cost of manufacturing at $17 per unit. The fixed cost of manufacturing operations is $10 Million per year. FX maintains 1 month of raw materials and 1 month of WIP and finished goods combined to balance overall automotive demand. Assume that FX has a federal tax rate of 25% and a state tax rate of 5%. Also assume that FX uses a MARR of 15% for all economic analyses.
b) If the company could borrow $10 Million of the $27 Million needed at 10%, how would this change the NPV calculation?
c) If inflation is estimated at 2% and the pricing is locked for the six year period, how does your NPV change? Assume that the company borrowed $10 Million of the $27 Million needed at 10%.
In: Finance
For each of the scenarios below, select whether a correct decision, a type I error, or a type II error was made.
1- A marketing manager determines that an increase in expenditure for a particular stream of social-media marketing will not result in an increase in the number of customers reached by that stream. After increasing the expenditure, the manager installs a tracking app that confirms the number of customers reached has not increased.
2-Looking at the results of an employee survey, an HR manager concludes that employees have been negatively impacted financially after their office was relocated to a new building. After further examination by the finance department, it is shown that their employees have been spending more on travelling costs due to the move.
3-A finance manager informs the CEO that the new product they have launched has generated above-average revenue. Further analysis of the data shows that no remarkable change in the average revenue has occurred.
4- After having conducted a customer satisfaction survey, a sales manager determines that customers are less satisfied with the company’s service compared to the same quarter last year. Analysis of the financial results indicates that a significant percentage of customers cancelled their subscription to the company’s service in the last quarter.
5- After an extended period of abnormal weather, a line manager concludes that the weather has had no impact on the production capabilities of the employees he manages. At the end of the financial period, it is shown that there was a decrease in production during the period of abnormal weather.
6-An office manager informs the housekeeping staff that a newly developed cleaning product will not have an impact on their health. A year after implementing the use of the new product, the housekeeping staff undergo routine medical evaluations and the doctor determines that their overall health has deteriorated.
7- A call-centre manager implements a new software system, claiming that it will increase the average number of calls the centre can attend to in rapid succession. In the long run, the data show that there was no change in the average number of calls attended to.
Question 2
A project manager is investigating the impact that a change in production schedule will have on the overall project. She states the null hypothesis as follows: “Extending the project timeline by one week will not result in increased project costs”. The alternative hypothesis is defined as follows: “Extending the project timeline by one week will result in increased project costs”. For each of the four possible scenarios below, select whether a correct decision, a type I error, or a type II error was made.
9-
|
1-The project manager determined that the timeline shift would result in increased project costs, when in fact no increase in costs occurred. 2- The project manager determined that the timeline shift would not result in increased project costs, when in fact no increase in costs occurred. 3- The project manager determined that the timeline shift would result in increased project costs, when in fact an increase in costs occurred. 4- The project manager determined that the timeline shift would not result in increased project costs, when in fact an increase in costs occurred. |
Choose...Type II error Correct decision Type I error |
In: Statistics and Probability
Linear Programming Problem 1:
George's Woodcarving Company manufactures two types of wooden toys: soldiers and trains. A soldier sells for $27 and uses $10 worth of raw materials. Each soldier manufactured increases George's variable labor and overhead costs by $14. A train sells for $21 and uses $9 worth of raw materials. Each Train built increases George's variable labor and overhead costs by $10. The manufacture of wooden soldiers and trains requires two types of skilled labor: carpentry and finishing. A soldier requires 3 hours of carpentry labor and 2 hours of finishing labor. A train requires 4 hours of carpentry labor and 1 hour of finishing labor. Each week, George's can obtain all the needed raw material but only 240 carpentry hours and 100 finishing hours. Demand for trains is unlimited, but at most 28 soldiers are bought each week. George wishes to maximize weekly profit (revenue – costs). The company wants to find out the optimal production strategy that maximizes the weekly profit.
First solve this problem graphically or using the Solver. Have the solved graph or spreadsheet ready. For graphical approach, you need to solve for the optimal solution by solving simultaneous equations after graphing.
Then answer the quiz questions.
1. How many decision variables are in this problem?
2. How many finishing hours are available in this problem?
3. What is the unit profit of a toy soldier? $____.
4. To produce 5 toy soldiers and 5 toy trains, how many carpentry hours are required?
5. To produce 5 toy soldiers and 10 toy trains, how many finishing hours are required?
6. In the optimal solution, how many toy soldiers are produced?
7. In the optimal solution, how many toy trains are produced?
8. What is the maximum total profit?
9. In the optimal solution, how many hours of carpentry labor in total are used?
10. In the optimal solution, how many hours of finishing labor in total are unused?
In: Advanced Math