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

Assignment of variance in variance calculation, Assignment of Variance in V...

Assignment of Variance in Variance Calculation In variances calculating, the calculations require to be detailed sufficient hence the responsibility for the variance can be a

Regression analysis- linear cost function, given the following : Constan...

given the following : Constant $21,800 Std.error of Y Est. 4,500 R squared 0.7832 Observations # 22 X coefficient 11.75 Std.error of Coef.

Absorbtion of overheads, interaction with an expert/cost accountant to kno...

interaction with an expert/cost accountant to know the overhead absorbtion policies and procedure followed

Direct labour rate variance, Direct Labour Rate Variance It is the dif...

Direct Labour Rate Variance It is the difference among the actual direct labour rate and the standard direct labour rate for the total hours worked. Utilizing an equation,

Long-term liabilities, Long-Term Liabilities: These are usually for mo...

Long-Term Liabilities: These are usually for more than one year. They cover almost all the outsider's liabilities not comprised in the current liabilities and provisions. Such

Co-ownership incentive scheme or profit sharing schemes, Co-ownership incen...

Co-ownership incentive scheme or Profit Sharing Schemes The organization permits for ownership whereby the employees are permitted to own a percentage of the shares in the fir

Example of profit volume graph, Example of Profit Volume Graph The sum...

Example of Profit Volume Graph The summary results of a company are given as: Product                        A B          C

Cost of labor, The number of workdays varies from month to month due to the...

The number of workdays varies from month to month due to the number of weekdays, holidays, days of vacation, and sick leave taken in the month. The number of units produced in a mo

Organize the accounting entries, JK is a motor dealership which organizes i...

JK is a motor dealership which organizes its financial statements to 30 November. In the year to 30 November 2009, transactions integrated the following: (a) JK had motor vehicl

Behavioral classification of costs, Behavioral Classification of Costs ...

Behavioral Classification of Costs Definition Cost behavior refers to the change in costs as increase or may decrease like the output level changes that are like we risin

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