Activity Based Costing And Budgeting: A Case Study

Calculations of Activity Based Costing

Activity based costing is the costing method which assists the management of the companies to evaluate the activities which a company performs and then assigns the indirect cost to each product accordingly. This case explains about the US bright product company which produces cakes and pastries. This case explains about the total cost per cake and the production cost of the company. Activity based costing method has been used to solve this case.  In first section, cost per unit has been calculated through dividing the total cost according to the cost drivers. Further, bill of activities have been prepared and lastly, product cost for lamington and detail about extra cost have been given.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

In this section of the case, cost per unit has been calculated through dividing the total cost according to the cost drivers. Following is the calculations of the total cost per unit of the company:

Calculations of Activity Based Costing

Activity

Activity cost

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Activity driver

Annual quantity

Cost per unit

Prepare annual cost

 $       5,000

Process receivable

 $     15,000

No of invoices

 $           5,000

 $           3.00

Process Payable

 $     25,000

No of purchase orders

 $           2,500

 $         10.00

Program Production

 $     28,000

No of production schedules

 $           1,000

 $         28.00

Process sales order

 $     40,000

No of sales orders

 $           4,000

 $         10.00

Dispatch sales order

 $     30,000

No of dispatches

 $           2,500

 $         12.00

Develop and test products

 $     60,000

Assigned directly to products

Load mixers

 $     14,050

No of batches

 $           1,000

 $         14.05

Operate mixers

 $     45,900

No of kg

 $      2,00,000

 $           0.23

Clean mixers

 $       6,900

No of trays

 $           1,000

 $           6.90

move mixture to filling

 $       3,450

No of cake

 $      2,00,000

 $           0.02

Clean trays

 $     20,000

No of trays

 $         16,000

 $           1.25

Fill trays

 $     16,000

No of cake

 $      8,00,000

 $           0.02

Move to baking

 $       8,000

No of trays

 $         16,000

 $           0.50

Set up ovens

 $     50,000

No of batches

 $           1,000

 $         50.00

Bake cakes/ pastries

 $  1,30,000

No of batches

 $           1,000

 $       130.00

Move to packing

 $     40,000

No of trays

 $         16,000

 $           2.50

Pack cakes/ Pastries

 $     80,000

No of cake

 $      8,00,000

 $           0.10

Inspect pastries

 $       2,500

No of pastries

 $         50,000

 $           0.05

The above calculations explain about the total cost of cake per unit through dividing the total cost according to their activity driver. Cost per unit of the company is $ 268.62 that depicts that if the company produces one cake than it would cost $ 268.62 to the company. Further, it also assists the company to make decisions about the production and the pricing of the product through concerning the cost per unit of the cake.

Further, bill of activities have been prepared of cakes and pastries of the company… Bill of activities is the list of various functions which are performed by the company while producing a unit of the product and services which is associated with the total cost of the resources that has been consumed. Basically, bill of material is used by the manufacturing and construction companies to manage the performance, production and the pricing of the products. Following is the calculations of the Bill of activities of the company:

Bill of Activities

Activity consumed

Annual quantity of activity driver

Cost per unit (According to driver)

Total amount

Process receivable

500

3.00

1500

Process Payable

200

10.00

2000

Program Production

100

28.00

2800

Process sales order

400

10.00

4000

Load mixers

100

14.05

1405

Operate mixers

30000

0.23

6885

Clean mixers

100

6.90

690

move mixture to filling

30000

0.02

517.50

Clean trays

2000

1.25

2500

Fill trays

100000

0.02

2000

Move to baking

2000

0.50

1000

Set up ovens

100

50.00

5000

Bake cakes/ pastries

100

130.00

13000

Move to packing

2000

2.50

5000

Pack cakes/ Pastries

100000

0.10

10000

Dispatch Sales order

500

12.00

6000

Develop and test product

600

600

Annual Production

100000.00

Cost per unit

0.65

The above table explains about the total cost per unit of the products. The total cost per unit of cakes is $ 0.65 which explains that the $ 0.65 worth of resources is associated with the total production of the company. Through these calculations, it has been explained to the company that the total bill of material of the company is $ 0.65 per unit. Bill of unit makes it simple for the companies to make various quick and better conclusions about the operations, pricing and the changes in the production function of the company. Bill of material is prepared by all the manufacturing companies to assist them for various decision making process.

Bill of Activities

At last, other cost has been evaluated which could be used by the companies to manage the production and the cost of the company. Through the evaluation on company and the total cost and bills of material of the company, it has been found that the most of the cost particulars have been used by the management of the company to calculate the cost per unit. But the annual cost has not been added by the company and this could make an impact over the total cost and the profit of the company. Thus, it is suggested to the Lamington to add the annual cost in the production cost to calculate the perfect cost of capital of the company. Otherwise, the total profit of the company would be affected.

Thus, through the above study, it has been evaluated that in case of Lamington, the cost per unit of the company is $ 268.62 that depicts that if the company produces one cake than it would cost $ 268.62 to the company. Further, the bill of material has been calculated. Through these calculations, it has been explained that the total bill of material of the company is $ 0.65 per unit. In addition, it is suggested to the Lamington to add the annual cost in the production cost to calculate the perfect cost of capital of the company. The above evaluation assists the company to make decisions about the production and the pricing of the product through concerning the cost per unit of the cake.

Budgeting is a procedure to make a plan about the spending the money and receiving the money in near future. Budgeting plan is prepared by every organization to evaluate the total earnings in future as well as the total expenditure of the company. Budgeting makes it easy for the organizations and the management of the company to make decisions about the strategies, policies, operations, production of the etc. Budgeting is basically a plan to balance the total income and the expenses of the company.

In this case, Hawthorn Leisure Works is preparing a plan to enhance the cash inflows of the company through making few changes in the membership plans and fess structure of the company. This case explains that the budgeting is the main part to evaluate the performance of the plan in near future. Following is the current and future plan of the company:

Total members

2000

Individual

 $       45

Student

 $       30

Family

 $     100

10 courts each club

Hourly court fees

 $         8

 $          12

Peak season:

Time

12

Hours a day

Capacity (Peak Season)

90%

100%

(5 pm to 9 pm)

181 days (Oct to April)

50%

60%

(9 am to 4 pm)

Off Season

20%

40%

 $         6

New plan (Annual fees 🙂

Individual

 $     300

50% are family

Family

 $     500

25% are students

25% are individual

Promotional Campaign

Individual

 $     250

Family

 $     450

45% of current members have opted for new plan from existing members

Rest 55% are using the same monthly plan

Other Cost Evaluation

Firstly, in this section, it has been evaluated that whether the new membership plan of the company would be able to enhance the cash receipts of the company. Following is the calculations of the present structure and the future plan of the company:

Present cash flow estimations of the company

Total number

Cash Inflow

Revenue:

Members

2000

Individual

 $              90,000

Family

 $           2,00,000

Student

 $              60,000

Off Season

 $      1,05,98,400

Peak Season

 $      3,88,06,400

Total cash inflow

 $      4,97,54,800

Future cash flow estimations of the company

Total number

Cash Inflow

Revenue:

Members

900

Individual

 $           1,35,000

Family

 $           2,25,000

Promotional Campaign

500

Individual

 $              62,500

Family

 $           1,12,500

Total cash inflow

 $           3,60,000

The above calculations explain that the cash flow timing of new project would be better but the total cash inflow of the company would be lower a lot in case of new plan as the main income of the club is from hourly rates and the new plan would be a barrier in the hourly fees of the company thus the present plan is way better than the current plan.

Through, the calculations of the new plan from 1st Oct to 31st Sept, following calculations have been measured:

Future cash flow estimations of the company

Total number

Cash Inflow

Revenue:

Members

900

Individual

 $           1,35,000

Family

 $           2,25,000

Promotional Campaign

500

Individual

 $              62,500

Family

 $           1,12,500

Total cash inflow

 $           3,60,000

It explains that the total cash receipts have taken place into the position of the company in 1st month (October month) itself according to the new plan. It has been assumed that the promotional campaign amount has been taken by the management of the club on 1st Oct itself and at the time of campaign, only registrations have been done.

According to the above evaluation over the project, it has been calculated that the new plan must not be accepted by the company as it would not offer that much cash receipts to the company as much as earn by the company right now. The calculations on present case and the future plan explain that the cash flow timing of new project would be better but the total cash inflow of the company would be lower a lot in case of new plan as the main income of the club is from hourly rates and the new plan would be a barrier in the hourly fees of the company thus the present plan is way better than the current plan.

Conclusion:

Thus, through the above evaluation, it has been found that the new plan must not be accepted by the company as it would not offer that much cash receipts to the company as much as earn by the company right now.

References:

Barney, Jay B. Gaining and sustaining competitive advantage. Pearson Higher Ed, (2014).

Cooper, Robin. Supply chain development for the lean enterprise: interorganizational cost management. Routledge, (2017).

Cooper, Robin. Supply chain development for the lean enterprise: interorganizational cost management. Routledge, (2017).

Fayard, Dutch, et al. “Interorganizational cost management in supply chains: Practices and payoffs.” Management Accounting Quarterly 15.3 (2014): 1.

Gryshchenko, N. V., N. A. Serebryakova, and V. V. Syroizhko. “?ethodology of cost management business organization in conditions of instability.” ? ?????: Sustainable economic development of regionsby L. Shlossman. Vienna (2015): 14.

Henri, Jean-François, Olivier Boiral, and Marie-Josée Roy. “Strategic cost management and performance: The case of environmental costs.” The British Accounting Review 48.2 (2016): 269-282.

Johnson, P. Fraser. Purchasing and supply management. McGraw-Hill Higher Education, (2014).

Klychova, G. S., et al. “Management aspects of production cost accounting in horse breeding.” Asian Social Science11.11 (2015): 308.

Mansor, Zulkefli, et al. “Issues and Challenges of Cost Management in Agile Software Development Projects.” Advanced Science Letters 22.8 (2016): 1981-1984.

Potts, Keith, and Nii Ankrah. Construction cost management: learning from case studies. Routledge, (2014).

Sechilariu, Manuela, Bao Chao Wang, and Fabrice Locment. “Supervision control for optimal energy cost management in DC microgrid: Design and simulation.” International Journal of Electrical Power & Energy Systems 58 (2014): 140-149.

Yim, Andrew. “Failure risk and quality cost management in single versus multiple sourcing decision.” Decision Sciences45.2 (2014): 341-354.

What Will You Get?

We provide professional writing services to help you score straight A’s by submitting custom written assignments that mirror your guidelines.

Premium Quality

Get result-oriented writing and never worry about grades anymore. We follow the highest quality standards to make sure that you get perfect assignments.

Experienced Writers

Our writers have experience in dealing with papers of every educational level. You can surely rely on the expertise of our qualified professionals.

On-Time Delivery

Your deadline is our threshold for success and we take it very seriously. We make sure you receive your papers before your predefined time.

24/7 Customer Support

Someone from our customer support team is always here to respond to your questions. So, hit us up if you have got any ambiguity or concern.

Complete Confidentiality

Sit back and relax while we help you out with writing your papers. We have an ultimate policy for keeping your personal and order-related details a secret.

Authentic Sources

We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.

Moneyback Guarantee

Still reluctant about placing an order? Our 100% Moneyback Guarantee backs you up on rare occasions where you aren’t satisfied with the writing.

Order Tracking

You don’t have to wait for an update for hours; you can track the progress of your order any time you want. We share the status after each step.

image

Areas of Expertise

Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.

Areas of Expertise

Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.

image

Trusted Partner of 9650+ Students for Writing

From brainstorming your paper's outline to perfecting its grammar, we perform every step carefully to make your paper worthy of A grade.

Preferred Writer

Hire your preferred writer anytime. Simply specify if you want your preferred expert to write your paper and we’ll make that happen.

Grammar Check Report

Get an elaborate and authentic grammar check report with your work to have the grammar goodness sealed in your document.

One Page Summary

You can purchase this feature if you want our writers to sum up your paper in the form of a concise and well-articulated summary.

Plagiarism Report

You don’t have to worry about plagiarism anymore. Get a plagiarism report to certify the uniqueness of your work.

Free Features $66FREE

  • Most Qualified Writer $10FREE
  • Plagiarism Scan Report $10FREE
  • Unlimited Revisions $08FREE
  • Paper Formatting $05FREE
  • Cover Page $05FREE
  • Referencing & Bibliography $10FREE
  • Dedicated User Area $08FREE
  • 24/7 Order Tracking $05FREE
  • Periodic Email Alerts $05FREE
image

Services offered

Join us for the best experience while seeking writing assistance in your college life. A good grade is all you need to boost up your academic excellence and we are all about it.

  • On-time Delivery
  • 24/7 Order Tracking
  • Access to Authentic Sources
Academic Writing

We create perfect papers according to the guidelines.

Professional Editing

We seamlessly edit out errors from your papers.

Thorough Proofreading

We thoroughly read your final draft to identify errors.

image

Delegate Your Challenging Writing Tasks to Experienced Professionals

Work with ultimate peace of mind because we ensure that your academic work is our responsibility and your grades are a top concern for us!

Check Out Our Sample Work

Dedication. Quality. Commitment. Punctuality

Categories
All samples
Essay (any type)
Essay (any type)
The Value of a Nursing Degree
Undergrad. (yrs 3-4)
Nursing
2
View this sample

It May Not Be Much, but It’s Honest Work!

Here is what we have achieved so far. These numbers are evidence that we go the extra mile to make your college journey successful.

0+

Happy Clients

0+

Words Written This Week

0+

Ongoing Orders

0%

Customer Satisfaction Rate
image

Process as Fine as Brewed Coffee

We have the most intuitive and minimalistic process so that you can easily place an order. Just follow a few steps to unlock success.

See How We Helped 9000+ Students Achieve Success

image

We Analyze Your Problem and Offer Customized Writing

We understand your guidelines first before delivering any writing service. You can discuss your writing needs and we will have them evaluated by our dedicated team.

  • Clear elicitation of your requirements.
  • Customized writing as per your needs.

We Mirror Your Guidelines to Deliver Quality Services

We write your papers in a standardized way. We complete your work in such a way that it turns out to be a perfect description of your guidelines.

  • Proactive analysis of your writing.
  • Active communication to understand requirements.
image
image

We Handle Your Writing Tasks to Ensure Excellent Grades

We promise you excellent grades and academic excellence that you always longed for. Our writers stay in touch with you via email.

  • Thorough research and analysis for every order.
  • Deliverance of reliable writing service to improve your grades.
Place an Order Start Chat Now
image

Order your essay today and save 30% with the discount code ESSAYHELP