New Perspectives Excel 2019 – Module 10 SAM Project 1b

Corvallis Group Restore ANALYZE DATA WITH POWER TOOLS    GETTING STARTED Open the file NP_EX19_10b_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as NP_EX19_10b_FirstLastName_2.xlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer: Support_EX19_10b_History.csv Support_Ex19_10b_Restore.accdb With the file NP_EX19_10b_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the…

Details

Patterson Manufacturing Company manufactures

Patterson Manufacturing Company manufactures part #52749 for use in its production cycle. The costs per unit for 10,000 units of part #52749 are as follows: Direct materials  $3 Direct labor  $15 Variable overhead  $6 Fixed overhead  $8 Blundell Company has offered to sell Patterson 10,000 units of part #52749 for $30 per unit. If Patterson accepts Blundell’s offer, the released facilities could be used to save $45,000 in relevant costs in the manufacture of part #60657. In addition, $5 per unit of the fixed overhead applied to part #52749 would be totally eliminated. Required: What are the total relevant costs to manufacture part #52749? What are the total relevant costs to buy part #52749? What alternative is more desirable and by…

Details

ACC512- Helen Croker owns Divine Denim, a growing company making made to measure

Helen Croker owns Divine Denim, a growing company making made to measure, designer denim jeans and jackets. She uses organic yarn-dyed cotton denim of different weights depending on the garment that she is making. Although she prefers to take the measurements herself, she is now making denim clothes for international customers using the self-measuring system she has developed and put online. For her custom clients, she takes measurements or uses the measurements supplied through her customers’ online application. She uses these measurements to alter the pattern for the design chosen by the client. The pattern is sent to the Cutting Department and the cut material then transferred to the Machining Department. Helen has recently expanded into a Ready to Wear (RTW)…

Details

Barry Bonza is the Managing Director of Bonza Juice Pty. Ltd.

Bonza Juice Pty Ltd Barry Bonza is the Managing Director of Bonza Juice Pty. Ltd. which operates a chain of stores located within major shopping malls.The flagship store is in the Warriewood Shopping Centre on the Northern Beaches of Sydney.The store currently achieves annual sales of $200,000 of fresh fruit juice, $20,000 of canned soft drinks and $15,000 of packaged flavoured milk drinks. Barry is interested in purchasing the Whizzer 2.0 for the Warriewood store, which can produce smoothies in addition to the usual fresh fruit juices.The machine currently sells for $300,000. In order to assess the suitability of the new machine, Barry consulted Barbara Boost from the famous Boost Juice family.Barbara charged $1,000 for her advice.This is immediately fully tax-deductible.…

Details

Jamie Ltd’s profit before tax for the year ended 30 June 2020 was

Question 1: Topic 1 – Accounting for Company tax Jamie Ltd’s profit before tax for the year ended 30 June 2020 was $172,400. Included in this profit are the following items of income and expense: Amortisation of development costs $12,000 Carrying amount of equipment sold 11,000 Depreciation – building (6%) 15,000 Depreciation – equipment (15%) 15,000 Depreciation – motor vehicle (20%) 5,800 Doubtful debts expense 1,700 Employee benefits expense 7,000 Entertainment expense  3,500 Fines and penalties 4,400 Goodwill impairment 2,000 Insurance expense 1,400 Interest revenue 800 Proceeds on sale of equipment  19,000 Rent revenue 15,000 Royalty revenue (exempt income) 3,000 Warranty expense 7,000   At 30 June, the company’s draft statements of financial position showed the following balances:   2020 2019…

Details

Edward has just purchased a callable bond and wants to determine the bond’s potential payoff price

Callable bond and call premium. Edward has just purchased a callable bond and wants to determine the bond’s potential payoff price if it is called at any time during its callable life. The callable bond is a twenty-year semiannual bond that an issuer can call starting at year ten. It is callable every six months on the coupon payment date. The call price is declining and starts out as one extra year’s coupon (a full annual coupon payment). It reduces each period (every six months by 1/20th of the annual coupon payment) until—at the bond’s maturity—there is no call premium price. If the original bond is an 8% bond (with 4% coupons paid semiannually), a par value of $1,000 and an…

Details

Jackman, Hugh, Eco, Fico, Amber and VStone – BAP32 – Corporate Accounting

Case 1: Accounting by the acquirer The trial balance of Jackman Ltd at 1 January 2019 was as follows:       Debit Credit Share capital       Preference – 15 000 fully paid shares   15000   Ordinary – 70 000 fully paid shares   70000 Retained earnings   43000 Equipment 84000   Accumulated depreciation – equipment   20000 Inventories 36000   Accounts receivable 33000   Investments 12000   Patents 7000   Debentures   8000 Accounts payable   16000     172000 172000   At this date, all the assets and liabilities of Jackman Ltd are sold to Hugh Ltd, with Jackman Ltd going into voluntary liquidation. The terms of acquisition are: Hugh Ltd is to take over all…

Details

Brooks_Chapter_4_2_Start – Amortization schedule. Sherry and Sam want to purchase a condo at the coast

Amortization schedule. Sherry and Sam want to purchase a condo at the coast. They will spend $650,000 on the condo and are taking out a $650,000 loan for the condo for twenty years at 7.0% interest. What is the annual payment on the mortgage? Construct the amortization schedule of the loan for the twenty years in a spreadsheet to show the annual interest costs, the principal reduction, and the ending balance each year. Then change the amortization schedule to reflect that after ten years Sherry and Sam will increase their annual payment to $80,000 per year. When will they fully repay the mortgage with this increased payment if they apply all the extra dollars above the original payment to the principal?…

Details

ACCT6001 Accounting Information Systems – Mark Richardson has recently opened an online store

The Flying Store   Mark Richardson has recently opened an online store named The Flying Store. He sells a very popular model of drone called the ‘Rocket Drone’. In an effort to widen his market, Mark has built a small website hosted by a web service provider. At the end of every week, the web service provider sends a data file to Mark that contains data about visitor traffic at his website. Mark would like to utilise this data to get insights on visitor usage of his website and he believes that the data would be valuable for business decision making. However, Mark lacks the technical knowledge to analyse and interpret this data and he is unsure how the results from…

Details

Certus Car Rental – John Tretow is an account manager

Data File needed for this case Problem: NP_eX_4-3.xlsx Certus Car Rental John Tretow is an account manager for the Certus Car Rental, an industry-leading car rental firm that serves customers across the United States and overseas. John is developing a market report for an upcoming sales conference and needs your assistance in summarizes market information into a collection of Excel charts and graphics. Complete the following. Open the NP_eX_4-3.xlsx workbook located in the Excel4 > Case1 folder included with your Data Files. Save the workbook as NP_eX_4_certus in the location specified by your instructor. In the Documentation sheet, enter your name and the date in the range B3:B4. John wants the report to include pie charts that break down the current…

Details

ACCG2000 Excel Assessment – JJ Cycles Ltd produce two high end bicycle

Scenario JJ Cycles Ltd produce two high end bicycle products at two different factories. They need you to create a spreadsheet that can conduct a Cost Volume Profit Analysis for a selected product line.  You can assume that sales price, fixed costs, and variable cost per unit are constant. You will need to calculate the labour costs, material costs, fixed costs and variable costs and then work out the break-even volume.  You have also been asked to show a forecast for different unit volumes and produce a break-even analysis line chart.   Start by downloading the assessment workbook from iLearn and copying/moving it to an appropriate folder. When you open the workbook it is very important that you Enable Macros and…

Details

New Perspectives Excel 2019 | Module 8: SAM Project 1b

Ferguson Fitness EXPLORE BUSINESS OPTIONS WITH WHAT-IF TOOLS       GETTING STARTED Open the file NP_EX19_8b_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_8b_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_8b_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. This project requires you to use the Solver add-in. If this add-in is not available on…

Details