College Pal
Connecting to a pal for your paper
  • Home
  • Place Order
  • My Account
    • Register
    • Login
  • Confidentiality Policy
  • Samples
  • How It Works
  • Guarantees

Sms or Whatsapp only : US:+12403895520

 

email: [email protected]
February 2, 2022

Cookie Business Final Presentation Now that you have completed running some calculations for the cookie business in Unit VII, y

Business & Finance /Accounting

 

Cookie Business Final Presentation

Now that you have completed running some calculations for the cookie business in Unit VII, you will present your findings.The learning objectives of this project allow you to apply accounting concepts and standards to the creation of accounting information and reports.Using your final project from Unit VII as a guide, create an eight- to ten-slide PowerPoint presentation. In this presentation, you want to summarize what you found and discuss how you think these findings will help you make better business decisions. In addition, provide future recommendations for the cookie business based on your report findings.Your presentation slides should be somewhat simple (incomplete sentences, bullets, etc.) with appropriate graphics or images. You must add content to your presentation (completed sentences) through either the notes feature in PowerPoint or by creating a video of you presenting your presentation, uploading your video to YouTube, and sharing the link to your video on the first or second slide of your presentation. 

  • attachment

    UnitVII_Final_Project_Template1.docx

  • attachment

    UnitVII_Spreadsheet_Template1.xlsx

1

10

Title of the Paper Goes Here

Student Name

Institution

ACC 5301 Management Applications of Accounting

Instructor

Date

Abstract

The contributing margin is used to compare the performance of different products and determine if they are profitable or not. It used in determining the products to put emphasis on and the product to do away with.

The present value is used to determine the current value of a future sum of money today at a specific rate of return. It is used to determine if an investment is worth investing.

Variance is used to determine the difference between standard and actual costs incurred in production. When the variance is unfavorable, the cost of production is higher than the standard cost while when the variance is favorable, the cost of production is lower than the standard cost.

Cookie Business Final Project

Contribution margin is the difference between revenue and variable costs (sales revenue- variable costs) this takes into account the net income which is obtained from net sales, variable costs, and fixed costs (Gutiérrez, 2021). The break-even point is the number of units the business needs to sell to cover fixed cost. The weighted average contribution margin is the average amount that a group of products contribute to paying the fixed costs of a business.

The variance in production is used to determine the deviation of cost incurred of production from the standard cost. This is important in developing ways to improve production and reducing wastage.

Material price variance is the difference between the standard price and the actual price for the actual quantity of material used in production. The material price variance is favorable when the standard material cost is higher than the actual material cost.

Part 1 Contribution Margin/Breakeven

Cookie Business

 

 

 

 

 

 

 

 

 

 

 

 

 

Chocolate Chip

Sugar

Specialty

Total

Units Sold

1,500,000

980,000

300,000

2,780,000

Sales

$ 1,875,000.00

$ 882,000.00

$ 1,050,000.00

$ 3,807,000.00

Less: Variable Costs

$ 690,000.00

$ 205,800.00

$ 81,000.00

$ 976,800.00

Contribution Margin

$ 1,185,000.00

$ 676,200.00

$ 969,000.00

$ 2,830,200.00

Less: Common Fixed Costs

 

 

 

$ 125,000.00

Profit

 

 

 

$ 2,705,200.00

 

 

 

 

 

Per item Contribution Margin

0.79

0.69

3.23

 

 

 

 

 

 

Weighted Average Contribution Margin

1.018

 

 

 

 

 

 

 

 

 

 

 

 

 

Break-even point in units

959,474

 

 

 

Data in business is used to make decisions. The number of sales made determine the demand while contribution margin determines if a product is profitable which is easily calculated using the contribution margin formula. Diversification is important in business although having products that does not generate cash flow can lead the business to bankruptcy. This makes contribution margin important. Products with low contribution margin means they are not performing well and the business owner can remove it from the production line. The business owner can also decide to promote another product that is generating a high contribution margin.

Contribution margin= net sales- variable cost

Contribution margin per unit= (net sales-variable cost)/number of units sold.

Per unit contribution margin helps to compare the different products where in our case specialty has the highest contribution margin then chocolate chips and lastly sugar meaning specialty generates the highest profit and then chocolate chips while sugar generates the least profit.

The weighted average contribution margin is the average amount that a group of products contribute to paying the fixed costs of a business. This is used in breakeven analysis.

Weighted average contribution margin= total of (contribution margin for each product*number of units sold)/total number of unit sales.

The products had a weighted average contribution margin above one which means the business is profitable and is paying the fixed costs.

The break-even point is the number of units the business needs to sell to cover fixed cost as explained by Gutierrez, & Dalsted, (1990). Which failure to cover them the business results in negative net profit and negative contribution margin.

Break-even point= fixed costs/per-unit contribution margin

The company break-even point is 959474 units.

Part 2 Full and Variable Costing

Cookie Business

 

 

Productions Costs:

 

Direct material

$ 0.60

Direct labor

$ 1.00

Variable manufacturing overhead

$ 0.40

Total variable manufacturing costs per unit

$ 2.00

 

 

Fixed manufacturing overhead per year

$ 139,000.00

 

 

In addition, the company has fixed selling and administrative costs:

 

Fixed selling costs per year

$ 50,000.00

Fixed administrative costs per year

$ 65,000.00

 

 

Selling price per cookie

$ 3.75

 

 

Number of cookies produced

2,780,000

Number of cookies sold

2,600,000

 

 

Full (absorption) costing :

 

Full cost per unit

$ 2.09

Ending Inventory Full (absorption) costing

$ 376,446

 

 

Variable costing :

 

Variable cost per unit

$ 2.00

Ending Inventory Variable costing

$ 360,000

Absorption costing is used in inventory valuation and calculating the cost of the product in companies where all the expenses incurred by the company are taken into consideration. The full absorption costing is obtained by adding up all the costs incurred in the production process and allocating them to the products individually as stated by Nawaz, (2013).

Full absorption cost =direct labor cost per unit+direct material cost per unit+variable manufacturing overhead cost per unit+fixed manufacturing overhead per unit.

This gives the total cost of producing each product.

The ending inventory full absorption costing is the number of goods left as inventory in the company multiplied with the full absorption cost per unit.

The variable cost per unit only considers the variable cost of production which include direct labor cost per unit, direct material cost per unit and variable manufacturing overhead cost per unit.

This cost is used in determining the per unit cost of production and amount of inventory cost left at the end of a period.

Part 3 Special Order

Cookie Business

 

 

 

 

Number of cookies needed

1,000

Discounted price per cookie

$ 2.75

Normal price per cookie

$ 3.75

Cost of special printed design per cookie

$ 0.50

Cost of tool needed to make the design

$ 100.00

 

 

 

 

Revenue for special order

$ 2,750

Costs for special order:

 

Design cost

$ 600

Tool cost

$ 2,691

Net increase (decrease) in profit

$ 59

The special order has a cost of production of $2.09 with an additional cost of design which makes the cost of production of the 1000 products to be $2691. The net revenue from sales of the 1000 product is $2750 after discount which makes the profit to be $59 from sales of the 1000 products.

Part 4 Internal Rate of Return

Cookie Business

 

 

 

 

 

As the owner of the Cookie Business, you are considering the following investment:

 

 

 

 

 

 

 

 

 

Purchase of new equipment

$ 250,000.00

 

 

 

Expected annual increase in sales

$ 48,017.50

 

 

 

Time frame

7

years

 

 

Acceptable rate needed

9%

 

 

 

 

 

 

 

 

Calculate the Internal Rate of Return:

 

 

 

 

PV of annuity factor

-8116.6455

 

 

 

Internal rate of return

5%

5.206435

 

 

 

 

 

 

 

Accept or reject

accept

 

 

 

The internal rate of return is a discount rate used to identify potential future investments that will be profitable. It is used to make the present value of an investment to zero. This shows the percentage return from the investment required for it to break even when adjusted for the value of time and money involved as explained by Bora, (2015). This gives the minimum acceptable return on investment. With a rate of 9 percent for 7 years the investment PV is a negative which shows that it has not yet completed paying back the amount invested.

The IRR is found to be 5% taking the time frame to be 5 years. This will ensure that the amount invested have been recovered from the profit obtained.

The transaction is biased as one of the partners is pushing for the equipment purchase with other agenda apart from one of increasing the company production. The partner wishes to promote his brother’s business. This is unethical as it will lead to purchase of the equipment with unnecessary urgency which resulted from provision of false data and information. There may be another alternative better than purchasing the equipment which might be foregone in the process of the partner promoting his brother’s business.

Part 5 Cash Budget

The budgeted credit sales are as follows:

 

 

 

 

 

 

 

December last year

$ 250,000

 

 

January

$ 125,000

 

 

February

$ 300,000

 

 

March

$ 90,000

 

 

 

 

 

 

Collection:

 

 

 

Month of the sale

80%

 

 

Month following the sale

20%

 

 

 

 

 

 

 

 

 

 

Estimated cash receipts

 

 

 

 

January

February

March

Last month's sales

$ 50,000

$ 25,000

$ 60,000

Current month's sales

$ 100,000

$ 240,000

$ 72,000

Total

$ 150,000

$ 265,000

$ 132,000

February has the highest sale and cash flow as well as having the highest credit sales. The higher the credit sales the higher the amount of cash flow that result in the company in the same month. When the previous month has high credit sale, this means that the current year sales will be boosted.

Part 6 Material and Labor Variance

Cookie Business

 

 

 

 

 

 

 

 

Actual Cost of Direct Materials

$ 225,000

 

 

Standard Cost of Direct Materials

$ 224,800

 

 

Actual Materials Used

30

 

 

Standard Materials Used

31

 

 

 

 

 

 

Actual Direct Labor Rate

$ 15.50

 

 

Standard Labor Rate

$ 15.00

 

 

Actual Hours Worked

45

 

 

Standard Hours Worked

40

 

 

 

 

 

 

 

Amount

Favorable/ Unfavorable

 

Calculate Materials Variances:

 

 

 

Materials Price Variance

$ (6,000)

unfavorable

 

Materials Quantity Variance

$ 224,800

favorable

 

 

 

 

 

Calculate Labor Variances:

 

 

 

Labor Rate Variance

$ (23)

unfavorable

 

Labor Efficiency Variance

$ (75)

unfavorable

 

The material price variance is the difference between the standard price and the actual price for the actual quantity of materials used for production. Material price variance results form price changes, poor purchasing procedures and deficiencies in price negotiation.

Material price variance= (standard price-actual price) *actual quantity

The project had a material price variance of a negative value which means it was unfavorable as more cost was incurred than the standard cost.

The material quantity variance was a positive value which is favorable as less material was used than the standard.

The labor rate variance was unfavorable as it had a negative value. the rate for labor was higher than the standard value. The labor efficiency variance was unfavorable as the actual hours worked were more than the standard hours of work. When the labor and price variance is unfavorable, the cost of production is higher than the standard and expected cost which means less profit.

Conclusions and Recommendations

The company deals with production of chocolate chip, sugar and specialty.

Variance is used to determine if the production process is operating at a cost higher than the standard cost or lower or operating at the standard cost. When the variance is unfavorable there is less profit earned as the cost of production is higher while when the variance is favorable, there is more profit as less cost is incurred in production.

The management team should focus in maintaining the material price variance, quantity variance, the labor rate and efficiency favorable so as to reduce the cost of production.

References

Bora, B. (2015). Comparison between net present value and internal rate of return. International journal of research in finance and marketing, 5(12), 61-71. https://www.academia.edu/download/41051869/comparison_between_NPV_and_IRR.pdf

Gutiérrez, M. (2021). Making better decisions by applying mathematical optimization to cost accounting: An advanced approach to multi-level contribution margin accounting. Heliyon, 7(2), e06096. https://www.sciencedirect.com/science/article/pii/S2405844021002012

Gutierrez, P. H., & Dalsted, N. L. (1990). Break-even method of investment analysis (Doctoral dissertation, Colorado State University. Libraries). https://www.extension.colostate.edu/docs/pubs/farmmgt/03759.pdf

Nawaz, M. (2013). An Insight Into the Two Costing Technique: Absorption Costing and Marginal Costing. BRAND. Broad Research in Accounting, Negotiation, and Distribution, 4(1), 48-61. https://brain.edusoft.ro/index.php/brand/article/view/382

,

CM Breakeven

Cookie Business
Chocolate Chip Sugar Specialty Total
Units Sold 1,500,000 980,000 300,000 2,780,000
Sales $ 1,875,000.00 $ 882,000.00 $ 1,050,000.00 $ 3,807,000.00
Less: Variable Costs $ 690,000.00 $ 205,800.00 $ 81,000.00 $ 976,800.00
Contribution Margin $ 1,185,000.00 $ 676,200.00 $ 969,000.00 $ 2,830,200.00
Less: Common Fixed Costs $ 125,000.00
Profit $ 2,705,200.00
Per item Contribution Margin 0.79 0.69 3.23
Weighted Average Contribution Margin 1.018
Break-even point in units 959,474

Full Variable

Cookie Business
Productions Costs:
Direct material $ 0.60
Direct labor $ 1.00
Variable manufacturing overhead $ 0.40
Total variable manufacturing costs per unit $ 2.00
Fixed manufacturing overhead per year $ 139,000.00
In addition, the company has fixed selling and administrative costs:
Fixed selling costs per year $ 50,000.00
Fixed administrative costs per year $ 65,000.00
Selling price per cookie $ 3.75
Number of cookies produced 2,780,000
Number of cookies sold 2,600,000
Full (absorption) costing :
Full cost per unit $ 2.09
Ending Inventory Full (absorption) costing $ 376,446
Variable costing :
Variable cost per unit $ 2.00
Ending Inventory Variable costing $ 360,000

Special Order

Cookie Business
Number of cookies needed 1,000
Discounted price per cookie $ 2.75
Normal price per cookie $ 3.75
Cost of special printed design per cookie $ 0.50
Cost of tool needed to make the design $ 100.00
Revenue for special order $ 2,750
Costs for special order:
Design cost $ 600
Tool cost $ 2,691
Net increase (decrease) in profit $ 59

IRR

Cookie Business
As the owner of the Cookie Business, you are considering the following investment:
PV of Annuity Table
Purchase of new equipment $ 250,000.00 n 1% 2% 3% 4% 5% 6% 8% 10% 12%
Expected annual increase in sales $ 48,017.50 1 0.9901 0.9804 0.9709 0.9615 0.9524 0.9434 0.9259 0.9091 0.8929
Time frame 7 years 2 1.9704 1.9416 1.9135 1.8861 1.8594 1.8334 1.7833 1.7355 1.6906
Acceptable rate needed 9% 3 2.941 2.8839 2.8286 2.7751 2.7233 2.673 2.5771 2.4869 2.4018
4 3.902 3.8077 3.7171 3.6299 3.546 3.4651 3.3121 3.1699 3.0374
Calculate the Internal Rate of Return: 5 4.8534 4.7135 4.5797 4.4518 4.3295 4.2124 3.9927 3.7908 3.6048
PV of annuity factor -8116.6455 6 5.7955 5.6014 5.4172 5.2421 5.0757 4.9173 4.6229 4.3553 4.1114
Internal rate of return 5% 5.2064351539 7 6.7282 6.472 6.2303 6.0021 5.7864 5.5824 5.2064 4.8684 4.5638
8 7.6517 7.3255 7.0197 6.7327 6.4632 6.2098 5.7466 5.3349 4.9676
Accept or reject accept 9 8.566 8.1622 7.7861 7.4353 7.1078 6.8017 6.2469 5.759 5.3283
10 9.4713 8.9826 8.5302 8.1109 7.7217 7.3601 6.7101 6.1446 5.6502
11 10.3676 9.7869 9.2526 8.7605 8.3064 7.8869 7.139 6.4951 5.9377
12 11.2551 10.5753 9.954 9.3851 8.8633 8.3838 7.5361 6.8137 6.1944
13 12.1337 11.3484 10.635 9.9857 9.3936 8.8527 7.9038 7.1034 6.4236
14 13.0037 12.1063 11.2961 10.5631 9.8986 9.295 8.2442 7.3667 6.6282
15 13.8651 12.8493 11.938 11.1184 10.3797 9.7123 8.5595 7.6061 6.8109

Cash Budget

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

Consider the internal and external factors that impact an organization’s success. Based on your reading thus far, which factors Corporate Annual Financial Report and Financial Statements PURPOSE: The purpose of this individual analysis and oral presentati

Related Posts

Business & Finance /Accounting

You are to assume you have been recently hired by The Company and have been assigned to a team that reports to the CEO of THE COM

Business & Finance /Accounting

Discuss the impact on the cognitive ability of the constant stress experienced by persons living in or near poverty levels. 2. Di

Business & Finance /Accounting

This should be a short report that identifies and explains each of the key resources you are using in your research. It should in

Why Choose Us

Best Essay Writing Services- Get Quality Homework Essay Paper at Discounted Prices

At the risk of sounding immodest, we must point out that we have an elite team of writers. Ours isn’t a collection of individuals who are good at searching for information on the Internet and then conveniently re-writing the information obtained to barely beat Plagiarism Software. Who can’t do that?

Our writers have strong academic backgrounds with regards to their areas of writing. A paper on History will only be handled by a writer who is trained in that field. A paper on health care can only be dealt with by a writer qualified on matters health care. Thesis papers will only be handled by Masters’ Degree holders while Dissertations will strictly be handled by PhD holders. With such a system, you needn’t worry about the quality of work. Quality isn’t just an option, it is the only option. We don’t just employ writers, we hire professionals.

We have writers spread into all fields including but not limited to Philosophy, Economics, Business, Medicine, Nursing, Education, Technology, Tourism and Travels, Leadership, History, Poverty, Marketing, Climate Change, Social Justice, Chemistry, Mathematics, Literature, Accounting and Political Science.

Our writers are also well trained to follow client instructions as well adhere to various writing conventional writing structures as per the demand of specific articles.

They are also well versed with citation styles such as APA, MLA, Chicago, Harvard, and Oxford which come handy during the preparation of academic papers.

They also have unrivalled skill in writing language be it UK English or USA English considering that they are native English speakers. You also needn’t worry about logical flow of thought, sentence structure as well as proper use of phrases.

Our writers are also not the kind to decorate articles with unnecessary filler words. We respect your money and most importantly your trust in us. In writing, we will be precise and to the point and fill the paper with content as opposed to words aimed at beating the word count.

Our shift-system also ensures that you get fresh writers each time you send a job. This helps overcome occupational hazards brought about by fatigue. Hence, quality will consistently be at the top.

From our writers, you expect; good quality work, friendly service, timely deliveries, and adherence to client’s demands and specifications.

Once you’ve submitted your writing requests, you can go take a stroll while waiting for our all-star team of writers and editors to submit top quality work.

How Our Website Works

Get an Essay from Us

College Essays is the biggest affiliate and testbank for WriteDen. We hire writers from all over the world with an aim to give the best essays to our clients.

Our writers will help you write all your homework. They will write your papers from scratch. We also have a team of editors who read each paper from our writers just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE.

Step 1
To make an Order you only need to click ORDER NOW and we will direct you to our Order Page. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Deadline range from 6 hours to 30 days.

Step 2
Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email.

Step 3
Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost.

Is it Safe to use our services?
We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper.

Pricing and Discounts
Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.
Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you.

Recent Posts

  • Create a 1 page fact sheet as per the directions that your healthcare organization could hypothetically use to explain the health or nursing informatics policy/regulation you selected.
  • Create a policy and regulation fact sheet
  • For this assignment you are going to identify a complex healthcare ethical dilemma facing the professional nurse in our multi-dimensional healthcare environment
  • Case Study Reflection Paper Assignment
  • Root cause analysis and active listening
College Pal

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018

Cookie Business
The budgeted credit sales are as follows:
December last year $ 250,000
January $ 125,000
February $ 300,000
March $ 90,000
Collection:
Month of the sale 80%
Month following the sale 20%
Estimated cash receipts
January February March
Last month's sales $ 50,000 $ 25,000 $ 60,000
Current month's sales $ 100,000 $ 240,000 $ 72,000