Determine sales revenue and net income, Cost Accounting

Assignment Help:

Students will prepare a Comprehensive Master Budget and Budgeted Financial Statements for Earrings Unlimited for the three-month period ending June 30. This includes: Sales Budget, Cash Receipts Budget, Merchandise Purchases Budget, Cash Disbursements Budget, Cash Budget, Budgeted Income Statement using the Contribution Format, and a Budgeted Balance Sheet. Students will also perform CVP analysis to determine the break-even point and complete a sensitivity analysis to a sales price change and a change in the price of purchases.

Project Requirements:

I. Complete the Earrings Unlimited Case on an individual basis using the Excel template found on Blackboard under Course Documents, Project. Enter your answer on the Worksheet labeled "Part I Answer." Use formulas in the cells for calculations (i.e., do not type in a total that you have determined with your calculator.)

II. Use CVP Analysis to determine the break-even point in units and sales dollars for Earrings Unlimited for the Quarter Ended June 30. You must show all calculations. Enter your response on the Project Excel file in the Worksheet labeled "Part II Answer."

III. Determine Sales Revenue & Net Income for the 3-month period ending June 30, and the ending Cash Balance as of June 30 assuming the unit Sales Price is expected to increase (effective April 1) to $12, and the unit Purchase Price is expected to increase (effective April 1) to $5. Reconcile the changes.

To solve this, use the Worksheets provided in the Project Excel file (i.e., the worksheets titled "If SP = $12," "If Purch Pr = $5," "If SP=$12; and Purch Pr = $5" ). In each Worksheet, start with the Base Case data (what you entered as "Part I Answer") and then change the budget and/or financial statement data affected by the change to the Sales Price and/or the change to the Purchases Price. For example, changing the unit sale price will cause changes to the sales budget, cash receipts budget, and summary cash budget... this will lead to a new Net Income and a new June 30 ending Cash Balance. With changes to Sales and/or Purchases Prices, items such as interest expense and inventory values will also change. Complete the chart found on the Project Excel file in the Worksheet labeled "Part III Answer."

Hint: If you have used formulas for all calculations in the Excel spreadsheet, this question will be simple.

Another Hint: In the Base Case (Part I) and in the scenarios in Part III, be careful to follow the rules that Earrings Unlimited has established with its bank with respect to taking out and repaying loans as this will impact other items.


Related Discussions:- Determine sales revenue and net income

Overhead anaylysis, the annual overhead costs for abc ltd which has 3 produ...

the annual overhead costs for abc ltd which has 3 production centeres and 2 service centers are as follows. indirect wages & supervision X 2million Y 2million 3 production departme

Prepare the journal entries to record depreciation, Moore Corporation follo...

Moore Corporation follows a policy of a 10% depreciation charge per year on all machinery and a 5% depreciation charge per year on buildings (the corporation uses the nearest full

Activity Based Costing, Multiple Versus Single Overhead Rates, Activity Dri...

Multiple Versus Single Overhead Rates, Activity Drivers Deoro Company has identified the following overhead activities, costs, and activity drivers for the coming year: Deoro p

What are fixed costs, The costs that are fixed irrespective of manufacture ...

The costs that are fixed irrespective of manufacture are fixed costs. EX: Rent, Depreciation. Fix cost is those cost who not alter in any time whether the production done or not

Accounting, Ask What is the major value of the weighted cost of capital cal...

Ask What is the major value of the weighted cost of capital calculation for the firm? question #Minimum 100 words accepted#

Advantages of average costing method, Average costing method has the follow...

Average costing method has the following main advantages: 1.It is a realistic costing method useful to management in analyzing operating results and appraising future production

High - low method of cost estimation, High - Low Method of Cost Estimation ...

High - Low Method of Cost Estimation Now, cost estimation is based upon the relationship between past level and past cost of activity. Variable cost is based on the relationsh

Mr, Extracts from P Co''s records for last month are as follows: ...

Extracts from P Co''s records for last month are as follows: BUDGET ACTUAL PRODUCTION 7,000 UNITS 7,200 UNITS Direct Material $42,000 $42,912 Calculate

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd