Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per unit produced: Direct materials $7.20 Direct labor 1.54 Variable overhead: Supplies 0.23 Maintenance 0.19 Power 0.18 Budgeted fixed overhead costs per month include supervision of $98,000, depreciation of $76,000, and other overhead of $245,000. In March, Nashler Company produced 170,000 units and had the following actual costs: Direct materials $1,220,000 Direct labor 268,300 Supplies 39,600 Maintenance 32,250 Power 30,520 Supervision 99,400 Depreciation 76,000 Other overhead 244,300 Required: 1. Prepare a performance report for Nashler Company comparing actual costs with the flexible budget for actual units produced. If there is no variance, enter "0" for the amount and select "NA" in the last column. Nashler Company Performance Report Actual Cost Flexible Budget Cost Variance Direct materials $ $ $ Favorable Direct labor Unfavorable Supplies Unfavorable Maintenance Favorable Power Favorable Supervision Unfavorable Depreciation NA Other overhead Favorable Total cost $ $ $ Unfavorable Feedback Budgets can be used to examine the efficiency and effectiveness of a company. 2. What if Nashler Company’s actual direct materials cost were $1,224,000? How would that affect the variance for direct materials? If an amount is zero, enter "0". The materials variance would be $ . The total cost variance would increase by $ .
In: Accounting
Clair Walsh wishes to purchase a(n) $630,000 house. She has accumulated a $110,000 down payment, but she wishes to borrow $520,000 on a 25-year mortgage. For simplicity, assume annual mortgage payments occur at the end of each year and there are no loan fees.
1. |
What are Walsh's annual payments if her interest rate is (a) 44%, (b) 66%, and (c) 10%, compounded annually? |
2. |
Repeat number 1 for a 20-year mortgage. |
3. |
Suppose Walsh had to choose between a 25-year and a 20-year mortgage, either one at a(n) 66% interest rate. Compute the total payments and total interest paid on (a) a 25-year mortgage and (b) a 20-year mortgage. |
In: Accounting
Please pretend for a moment that you are the accounts receivable manager for JBX Industries, a local manufacturing company. JBX has the following issues as of 12/31/2017:
1. It is sitting on nearly $1 million in accounts
receivable.
2. However, almost $100,000 of that amount is expected to be
uncollectible.
3. JBX needs this cash to purchase additional raw materials for its
future sales.
What are some ways you could collect on these receivables? What kind of credit policies would you put in place to ensure you only took on the best clients?
In: Accounting
On January 1, the first day of the fiscal year, a company issues a $1,350,000, 11%, five-year bond that pays semiannual interest of $74,250 ($1,350,000 x 11% x ½), receiving cash of $1,512,610. Journalize the bond issuance. Refer to the Chart of Accounts for exact wording of account titles.
CHART OF ACCOUNTS- General Ledger
ASSETS- 110 Cash, 111 Petty Cash, 121 Accounts Receivable, 122 Allowance for Doubtful Accounts, 126 Interest Receivable, 127 Notes Receivable, 131 Merchandise Inventory, 141 Office Supplies, 191 Land, 194 Office Equipment, 195 Accumulated Depreciation-Office Equipment
LIABILITIES- 210 Accounts Payable, 221 Salaries Payable, 231 Sales Tax Payable, 232 Interest Payable ,241 Notes Payable,251 Bonds Payable, 252 Discount on Bonds Payable, 253 Premium on Bonds Payable
EQUITY- 311 Common Stock, 312 Paid-In Capital in Excess of Par-Common Stock, 315 Treasury Stock, 321 Preferred Stock, 322 Paid-In Capital in Excess of Par-Preferred Stock, 331 Paid-In Capital from Sale of Treasury Stock, 340 Retained Earnings, 351 Cash Dividends, 352 Stock Dividends, 390 Income Summary
REVENUE- 410 Sales, 610 Interest Revenue, 611 Gain on Redemption of Bonds
EXPENSES- 510 Cost of Merchandise Sold, 515 Credit Card Expense, 516 Cash Short and Over, 522 Office Salaries Expense, 531 Advertising Expense, 532 Delivery Expense, 533 Repairs Expense, 535 Rent Expense, 536 Insurance Expense, 537 Office Supplies Expense, 541 Bad Debt Expense, 562 Depreciation Expense-Office Equipment, 590 Miscellaneous Expense, 710 Interest Expense, 711 Loss on Redemption of Bonds
In: Accounting
On October 31, 2017, Cool Company sells a truck that originally cost 140,000 $ for 95,000$ cash. The truck was placed in service on January 1, 2012. It was depreciated using the straight-line method with an estimated salvage value of 28,000 and a useful life of 10 years. Record all the transaction. On July 19, 2018, Cool Co. purchased a machine for 260,000 SA from Saudi Machine Company (SMC). Omar gave SMC 7% note due in 120 days in payment for the machine. What is the maturity date of the note? How much interest will Omar pay to SMC on this note? Record the note? On October 16, 2018, Cool informs us that the company is unable to pay the note or interest?
In: Accounting
Oriental Hotel Bhd owned a few hotels in Malaysia. Their hotel in Melaka is set against a picturesque vista of Melaka’s most famous historical landmarks pf Melaka Raya. The location is close to Melaka City Centre with cheerful nightlife and mere minutes from the acclaimed UNESCO World Heritage site. The office management operates in the same hotel building as the hotel services provided to its guest. The company itself manages the hotel except for the laundry services which was transferred to its tenant, Cuci-Cuci Services Sdn. BHd.
Oriental Hotel Bhd take another step forward in its expansion plan with the opening a new hotel in the southern region in Malaysia. On 1 January 20X5, the company acquired a land for RM3,200,000 to construct a 4-star hotel building in Pangerang, Johor. Construction of the hotel building commenced on 1 March 20X5 and it was completed on 31 January 20X7, but was only used on 1 March 20X7.Total construction cost incurred excluding borrowing costs were RM34,000,000. The construction cost also includes the rectification of RM200,000. In order to finance the construction, the company took an 8%, 3 year-term loan of RM30,000,000 on 1 February 20X5. The company received a government grant of RM1,400,000 on 1 February 20X7 for the newly constructed hotel building. It is the company’s policy to use deferred income method for the government grant received.
Required:
Explain the accounting treatment for government grant received and
how will it differ from the alternative method.
In: Accounting
4. Greener Grass Fertilizer Company plans to sell 210,000 units of finished product in July and anticipates a growth rate in sales of 5 percent per month. The desired monthly ending inventory in units of finished product is 75 percent of the next month’s estimated sales. There are 157,500 finished units in inventory on June 30. Each unit of finished product requires 5 pounds of raw material at a cost of $1.25 per pound. There are 750,000 pounds of raw material in inventory on June 30.
Required:
Compute the company’s total required production in units of finished product for the entire three-month period ending September 30. (Round all intermediate calculations and your final answer to the nearest unit.)
Independent of your answer to requirement (1), assume the company plans to produce 800,000 units of finished product in the three-month period ending September 30, and to have raw-material inventory on hand at the end of the three-month period equal to 25 percent of the use in that period. Compute the total estimated cost of raw-material purchases for the entire three-month period ending September 30.
In: Accounting
1.) In cell H9 create a VLOOKUP to indicate the description Expensive for pups priced $2,000 or more, Moderate for pups priced $1,000 or more but below $2,000, Good Dealfor pups priced $500 or more but less than $1,000 and Cheapfor all pups priced less than $500. Begin the lookup table in cell E1. Copy the VLOOKUP in cell H9 to cells H10:H202. 2.) In cell I9 create a Nested IF to duplicate the results of #1 above. Copy the nested If in cell I9 to cells I10:I202. 3.) Sort the database by AKC Group and within AKC Group by Breed and within Breed by Color (all ascending order). Create a Subtotal report showing the average price by AKC Group and the total number of pups available for each dog breed. Change to outline level 3. Right-mouse click on the Sheet 1worksheet tab. Select “Move or Copy” and check mark “Create a copy” and click on (move to end). Name the newly created worksheet tab, “Subtotal.” Return to Sheet1and remove the subtotal report by clicking on the “Remove All” button in the Data/Subtotal menu. 4.) Use the “unique records only” feature of the Advanced Filter to indicate the unique varieties of dog colors and breeds. Start the unique dog breeds in K1 and the unique dog colors in M1. Place the unique dog breed and dog color combinations starting in cell O1. (You will have to do three separate Unique Advanced Filters.) 5.) Note that none of the filters in #4 require a criterion. To demonstrate a Unique Filter witha Criteria output the unique breeds with a price of $2,500 or more. Start your criteria in R1. Start your output in R4. Output just the Breed names that meet the criteria. (Check figure: 8) 6.) Insert a new worksheet. On Sheet 3, create a one variable data table that indicates the total number of pups available for each breed and the average price for each breed. (Copy/paste the Unique dog breeds extracted in #4.) Place the northwest corner of the table in cell A5. Begin the required criteria range in cell A1.7.) Insert a new worksheet. On Sheet 4, create a two variable data table that indicates the total number of pups available by dog breed and by dog color. (Use the unique dog breeds & unique colors extracted in #4. Use the copy & paste special / transpose to copy vertical text as horizontal text.) Place the northwest corner of the table in cell A5. Begin the required criteria range in cell A1. 8.) Turn off the display of zeroes in Sheet 4. File ribbon / Excel Options/Advanced (scroll down to Display Options for this Worksheet: Sheet 4) Remove the check mark in front of: Show a zero in cells that have a zero value. 9.) Create a pivot table that indicates the total number of pups available by breed and the average price for each breed. Place the northwest corner of the pivot table in cell E4 on Sheet 3. 10.) Create a pivot table that indicates the total number of pups available by dog breed and by dog color. Place the pivot table as a new worksheet.
Breeder | Dog | No. of | Welp | |||||
ID# | AKC Group | Breed | Color | Pups | Date | Price/Pup | Vlookup | IF |
912 | Non-Sporting | Dalmatian | Black | 4 | 2/13/20 | $ 800 | ||
749 | Toy | Chihuahua | Black | 2 | 8/11/18 | $ 475 | ||
449 | Sporting | Brittany | Tri | 3 | 6/20/20 | $ 650 | ||
833 | Hound | Saluki | White | 2 | 7/7/18 | $ 2,500 | ||
502 | Sporting | Labrador Retriever | Black | 10 | 7/22/20 | $ 301 | ||
723 | Hound | Afghan Hound | White | 1 | 3/23/18 | $ 1,500 | ||
288 | Sporting | Curly-Coated Retriever | Liver | 2 | 11/27/18 | $ 600 | ||
581 | Toy | Miniature Pinscher | Black | 7 | 10/17/19 | $ 500 | ||
689 | Terrier | Bedlington Terrier | Tan | 3 | 4/20/18 | $ 950 | ||
456 | Terrier | Staffordshire Bull Terrier | Black | 1 | 10/28/18 | $ 800 | ||
414 | Herding | Border Collie | Red | 1 | 4/26/20 | $ 500 | ||
672 | Working | Great Dane | Black | 6 | 12/18/20 | $ 825 | ||
777 | Terrier | Smooth Fox Terrier | Tri | 7 | 9/11/19 | $ 150 | ||
601 | Working | Akita | White | 1 | 10/31/19 | $ 3,000 | ||
555 | Sporting | Labrador Retriever | Chocolate | 2 | 4/10/18 | $ 150 | ||
789 | Toy | Pomeranian | Blue | 2 | 7/24/18 | $ 1,500 | ||
989 | Toy | Toy Fox Terrier | Tri | 1 | 3/11/18 | $ 199 | ||
337 | Working | Bernese Mountain Dog | Black | 2 | 1/16/19 | $ 1,750 | ||
589 | Herding | Shetland Sheepdog | Sable | 4 | 11/25/19 | $ 1,300 | ||
459 | Working | Great Dane | Blue | 2 | 10/8/19 | $ 2,800 | ||
978 | Terrier | Bull Terrier | White | 4 | 7/14/18 | $ 825 | ||
914 | Hound | American Foxhound | Tri | 5 | 6/5/20 | $ 900 | ||
419 | Sporting | Irish Setter | Red | 7 | 6/26/18 | $ 600 | ||
414 | Herding | Border Collie | Blue | 5 | 5/29/19 | $ 299 | ||
648 | Terrier | Irish Terrier | Red | 3 | 9/3/19 | $ 600 | ||
815 | Toy | Affenpinscher | Black | 2 | 5/12/18 | $ 2,000 | ||
382 | Toy | Maltese | White | 3 | 4/7/18 | $ 800 | ||
243 | Terrier | Smooth Fox Terrier | Tri | 8 | 1/31/19 | $ 85 | ||
348 | Sporting | German Shorthaired Pointer | Liver | 1 | 9/15/18 | $ 350 | ||
603 | Sporting | Labrador Retriever | Yellow | 9 | 5/31/18 | $ 300 | ||
178 | Hound | Bloodhound | Red | 3 | 1/10/20 | $ 1,750 | ||
456 | Terrier | Staffordshire Bull Terrier | Red | 1 | 9/26/19 | $ 800 | ||
766 | Terrier | Cairn Terrier | Red | 3 | 2/2/18 | $ 850 | ||
555 | Sporting | Labrador Retriever | Black | 11 | 3/25/19 | $ 301 | ||
288 | Sporting | Curly-Coated Retriever | Black | 4 | 5/27/19 | $ 600 | ||
449 | Herding | Cardigan Welsh Corgi | Sable | 1 | 6/5/20 | $ 600 | ||
651 | Sporting | Cocker Spaniel | Tan | 4 | 5/8/20 | $ 180 | ||
258 | Terrier | Staffordshire Bull Terrier | White | 2 | 6/16/20 | $ 1,100 | ||
414 | Herding | Border Collie | Chocolate | 2 | 1/25/18 | $ 500 | ||
112 | Non-Sporting | Chow Chow | Black | 5 | 10/28/19 | $ 250 | ||
457 | Working | Great Pyrenees | White | 4 | 2/19/19 | $ 450 | ||
749 | Toy | Chihuahua | Tan | 3 | 6/30/18 | $ 475 |
In: Accounting
explain different methods of presenting analysis of expenses and how we should choose these methods for application in company
In: Accounting
This question regards life insurance:
In: Accounting
Problem 11-18 Relevant Cost Analysis in a Variety of Situations [LO11-2, LO11-3, LO11-4]
Andretti Company has a single product called a Dak. The company normally produces and sells 120,000 Daks each year at a selling price of $48 per unit. The company’s unit costs at this level of activity are given below:
Direct materials | $ | 6.50 | |
Direct labor | 9.00 | ||
Variable manufacturing overhead | 3.70 | ||
Fixed manufacturing overhead | 5.00 | ($600,000 total) | |
Variable selling expenses | 1.70 | ||
Fixed selling expenses | 4.50 | ($540,000 total) | |
Total cost per unit | $ | 30.40 | |
A number of questions relating to the production and sale of Daks follow. Each question is independent.
Required:
1-a. Assume that Andretti Company has sufficient capacity to produce 162,000 Daks each year without any increase in fixed manufacturing overhead costs. The company could increase its unit sales by 35% above the present 120,000 units each year if it were willing to increase the fixed selling expenses by $120,000. What is the financial advantage (disadvantage) of investing an additional $120,000 in fixed selling expenses?
1-b. Would the additional investment be justified?
2. Assume again that Andretti Company has sufficient capacity to produce 162,000 Daks each year. A customer in a foreign market wants to purchase 42,000 Daks. If Andretti accepts this order it would have to pay import duties on the Daks of $3.70 per unit and an additional $29,400 for permits and licenses. The only selling costs that would be associated with the order would be $2.40 per unit shipping cost. What is the break-even price per unit on this order?
3. The company has 800 Daks on hand that have some irregularities and are therefore considered to be "seconds." Due to the irregularities, it will be impossible to sell these units at the normal price through regular distribution channels. What is the unit cost figure that is relevant for setting a minimum selling price?
4. Due to a strike in its supplier’s plant, Andretti Company is unable to purchase more material for the production of Daks. The strike is expected to last for two months. Andretti Company has enough material on hand to operate at 25% of normal levels for the two-month period. As an alternative, Andretti could close its plant down entirely for the two months. If the plant were closed, fixed manufacturing overhead costs would continue at 40% of their normal level during the two-month period and the fixed selling expenses would be reduced by 20% during the two-month period.
a. How much total contribution margin will Andretti forgo if it closes the plant for two months?
b. How much total fixed cost will the company avoid if it closes the plant for two months?
c. What is the financial advantage (disadvantage) of closing the plant for the two-month period?
d. Should Andretti close the plant for two months?
5. An outside manufacturer has offered to produce 120,000 Daks and ship them directly to Andretti’s customers. If Andretti Company accepts this offer, the facilities that it uses to produce Daks would be idle; however, fixed manufacturing overhead costs would be reduced by 30%. Because the outside manufacturer would pay for all shipping costs, the variable selling expenses would be only two-thirds of their present amount. What is Andretti’s avoidable cost per unit that it should compare to the price quoted by the outside manufacturer?
In: Accounting
Workpaper Entries and Consolidated Net Income for Two Years, Cost Method LO 6 LO 3 LO 5 On January 1, 2014, Palmero Company purchased an 80% interest in Santos Company for $2,800,000, at which time Santos Company had retained earnings of $1,000,000 and capital stock of $500,000. On the date of acquisition, the fair value of the assets and liabilities of Santos Company was equal to their book value, except for property and equipment (net), which had a fair value of $1,500,000 and a book value of $600,000. The property and equipment had an estimated remaining life of 10 years. Palmero Company reported net income from independent operations of $400,000 in 2014 and $425,000 in 2015. Santos Company reported net income of $300,000 in 2014 and $400,000 in 2015. Neither company declared dividends in 2014 or 2015. Palmero uses the cost method to account for its investment in Santos. Required: A. Prepare in general journal form the entries necessary in the consolidated statements work papers for the years ended December 31, 2014 and 2015. B. Prepare a schedule or t-account showing the calculation of the controlling and non controlling interest in consolidated net income for the years ended December 31, 2014 and December 31, 2015.
In: Accounting
Useful Art Inc. creates and manufactures objects that are characterized by both utility and artistry. One of its most popular products is the trivet (a 3-legged hot plate). The top of each trivet is a unique, handmade ceramic tile. Useful Art buys the tiles from artists and the trivet legs from a metal-working company, then assembles the trivets in-house. Towards the end of 2015, Useful Art prepares monthly budgets for 2016 using the following assumptions and data:
2015 actual sales:
Jan 300 u
Apr 350 u
Feb 325 u
May 345 u
Mar 275 u
Jun 370 u
Selling price per unit 50 $/u
Useful Art plans to launch a marketing campaign in 2016 that should increase sales (units) by 10% over 2015 sales as long as the selling price remains unchanged. Because each trivet is unique, management wants to have a substantial number of trivets on hand at all times so that customers can choose from among many options. So management plans to have 20% of next month's sales (units) on hand at the end of each month. The artists from whom Useful Art purchases the ceramic tiles do great work, but are sometimes a bit unreliable as to when they deliver the tiles. So management wants to have 30% of next month's production needs (tiles) on hand at the end of each month. The metal-working supplier is very reliable, so management wants to have just 15% of next month's production needs (legs) on hand at the end of each month Useful Art pays $35 per tile. • Useful Art pays $.45 per leg. • Useful Art has collected the following data related to cash inflows from sales: 20% of sales revenues are collected in the month of sale 70% of sales revenues are collected in the month after the sale 10% of sales revenues are collected two months after the sale
REQUIRED: Prepare the following budgets on a monthly basis for Useful Art for 2016: 1. Sales Budget (first two quarters of 2016) 2. Production Budget (first quarter of 2016) 3. Materials Purchases Budget (tiles) (first quarter of 2016) 4. Materials Purchases Budget (legs) (first quarter of 2016) 5. Cash Receipts (AKA Cash Collections) Budget (second quarter of 2016)
In: Accounting
Black Mountain Ski Resort has been granted a 20 - year permit to develop and operate a skiing operation in a national park. After 20 years the site must be returned to its original condition. The roads may remain, as they can be used for fire prevention purposes. In the spring and summer before the ski hill opened, the following transactions and events occurred:
You must use the following Long-Lived asset accounts
Ski Lift
Ski Chalet
Land improvement
Roads
Parking lot
Using Straight Line Depreciation record the depreciation for the first year of operations on the Long-Lived assets and site restoration costs. Put all the depreciation expense in one account and then create accumulated depreciation accounts for each asset that requires depreciation.
Allocate the interest expense on the site restoration costs for the first three years
Using the table below prepare the balance sheet presentation of all the accounts involved in this question for the end of the third year of operations.
Cost |
Accumulated Depreciation |
Net Carrying Amount |
|
Property Plant and Equipment |
|||
Ski Lift |
|||
Ski Chalet |
|||
Land Improvement |
|||
Roads |
|||
Parking Lot |
|||
Site Restoration Costs |
|||
Total Property Plant and Equipment |
Long Term Liabilities
Obligation for future restoration =
At the end of the project the actual cost of restoring the site is $43,000,000, as originally estimated. Prepare the journal entry to record the payment of these costs at the end of the project
Date |
Explanation/ Account |
Debit |
Credit |
what would be the total expenses associated with the site restoration in the first, second and 20th year?
Year |
Depreciation of Site Restoration Costs |
Interest expense accrual on obligation for future site restoration |
Total Expense relating to site restoration |
1 |
|||
2 |
|||
20 |
Calculations
In: Accounting
Nonsense Pty Ltd has 6 shareholders, each of whom is a director involved in a day to day operations of the company. Nonsense Pty Ltd has only 8 full time employees each of whom has direct personal contract with the directors.
The financial statements of Nonsense Pty Ltd for the year ended
30 June 2019 show:
- GROSS ASSETS OF $40,000,000
a LIABILITY OF 9000,000 owed entirely to a public sector bank
and
- Gross revenues of $60000,000
Explain, justifying your answer, if Nonesence Pty Ltd is required
by the Corporations Act 2001 to produce an annual report according
to AASB accounting standards for the year ending 30 June 2019?
In: Accounting