Category: Accounting

Please make sure you have access to the book “Horngren’s Financial and Managerial Accounting: The Managerial Chapters, 8e” Eighth edition by Tracie Miller-Nobles, Brenda Mattison. Read Chapter 7 “Master Budgets”. Please read the “assignment instructions” in the file for details

Conduct a Return on Investment (ROI) Analysis using Excel from year 1 up to year 10
I sent two format but they are the same thing , just wanted to make sure either one opens.
Note*** I provided an example below . Please let me know if you need more information.

What are some challenges of general long-term liabilities and what are the nuances that make the general long-term liabilities (not just long-term liabilities)?

NuComp Company operates in a state where corporate taxes and workers’ compensation insurance rates have recently doubled. NuComp’s president has just assigned you the task of preparing an economic analysis and making a recommendation relative to moving the entire operation to Missouri. The president is slightly in favor of such a move because Missouri is his boyhood home and he also owns a fishing lodge there.
You have just completed building your dream house, moved in, and sodded the lawn. Your children are all doing well in school and sports and, along with your spouse, want no part of a move to Missouri. If the company does move, so will you because the town is a one-industry community and you and your spouse will have to move to have employment. Moving when everyone else does will cause you to take a big loss on the sale of your house. The same hardships will be suffered by your coworkers, and the town will be devastated.
In compiling the costs of moving versus not moving, you have latitude in the assumptions you make, the estimates you compute, and the discount rates and time periods you project. You are in a position to influence the decision singlehandedly.
Identify 2 stakeholders and 2 ethical issues in this situation. How would you go about responding?

Please describe how you have prepared for your intended major, including your readiness to succeed in your upper-division courses once you enroll at the university.

Lion’s Lager Case Study
Part D: Differential Analysis and Investment Evaluation
Case Facts
Expanding Event Services
Following the successful launch of Lion’s Lager’s limited-edition seasonal beer, “Autumn
Amber,” the company is exploring the expansion of its event services to enhance profitability.
Currently, Lion’s Lager provides public brewery tours and tastings, but management believes
there is significant potential in expanding these services to include private events, such as
corporate gatherings and birthday parties. All private events would also include catering.
Management is keen to assess two options for this expansion. Costs required for each option are
provided below:
Table I: Expanding Event Services Options
Description Public Tours and Tasting Private Event Hosting
Staff members 2 6
Hours per staff member 2 hours 4 hours
Event staff wage rate $15 per hour $20 per hour
Catering cost $0 $30 per guest
Monthly fixed expenses $800 $2,500
Based on customer surveys, management anticipates hosting 4 private events each month, with
an average of 30 guests per event. All events are a flat fee of $3,000, limited to 60 guests. If the
company invests in additional public tours instead, it anticipates an additional 25 tours each
month, with an average of 14 guests on each tour. Tours are offered at $15 per guest.
From a marketing standpoint, Lion’s Lager has invested heavily in marketing to the local college
students. The company’s goal is to build their brand and reputation among the college
demographic, and to become the primary local attraction to college students.
Investment Evaluation
Lion’s Lager is also considering two key pieces of equipment necessary for improving the
brewery process: a Bottling Line and a Filtration System. The estimated investment and returns
of each piece of equipment are summarized in Table II:
Table II: Equipment Investment
Description Bottling Line Filtration System
Initial investment $150,000 $100,000
Expected annual revenue increase $50,000 $35,000
Annual operating costs $20,000 $10,000
The bottling line will enhance the overall presentation and packaging quality of the product,
improving brand recognition and perception among customers. It also will improve production
rates, which is crucial for efficiently launching seasonal flavors. On the other hand, the filtration
system will enhance the flavor profile and help ensure compliance with industry standards and
regulations.
Instructions
Your cost management team is tasked with conducting the following analysis:
• Differential analysis comparing the expanded public tours and tastings and private events
• Investment evaluation of the bottling line and filtration system equipment
For both analyses, please make a recommendation to management based on both the quantitative
and qualitative analysis of each decision.
Please ensure all calculations are performed in Excel, and all findings, analysis, and
recommendations are professionally summarized in a corresponding report. Please adhere to
generally accepted professional business writing parameters.
You are permitted to utilize AI resources for the completion of this case study, but that process
(prompts and the responses) must be well documented and submitted with your report
deliverables. Your group is not permitted to collaborate or share findings among other groups.
Doing so is academically dishonest, and will result in a 0% on the assignment for all students
involved. You are permitted and encouraged to seek assistance from your instructor.

Assume you are a manager working for a manufacturer of consumer product goods. Using the attached RFID reader and tag data, arrive at answers to the following questions:
On what days did a given pallet with EPC 48 3 5 0614141 000734 347900 move from one location to another? What are the chronological movements of the pallet?
(A) What is the average time taken between producing a pallet at our facilities and the pallet reaching a retail store? (B) What is the average time taken between producing a pallet at our facilities and the pallet reaching a retail store for each of the following specific product categories: Pallet of Diapers, Pallet of Soaps, Pallet of Detergents, Pallet of Probiotics? (C) How do the averages for each product category in part (B) compare to the overall average in part (A)?
What is the average number of days that a pallet is spending in the distributor’s warehouse? Hint: On a sheet named “Question 3,” create two separate pivot tables with EPC Read and Tag Read Date and Time. For both pivot tables, filter by “Type of Interaction”. For the first pivot table, filter by “Pallet loaded on a shipping truck” and select MAX of Tag Read Date and Time. For the second pivot table, filter by “Pallet stored in the warehouse” and select MIN of Tag Read Date and Time. Now subtract the MIN time (second pivot table) from the MAX time in the first pivot table to obtain the total days a pallet is spending in the warehouse. Now take the average of these days.
What is the average number of days that shipping trucks are taking to deliver a pallet from the manufacturing facility to the distributor’s warehouse? Hint: On a sheet named “Question 4,” create two separate pivot tables with EPC Read and Tag Read Date and Time. For both pivot tables, filter by “Type of Interaction”. For the first pivot table, filter by “Pallet loaded on a shipping truck” and select MIN of Tag Read Date and Time. For the second pivot table, filter by “Pallet stored in the warehouse” and select MIN of Tag Read Date and Time. Now subtract the two MIN times in the two pivot tables to obtain the total days it takes shipping trucks to deliver product form manufacturing facility to the warehouse. Now take the average of these days.
What is the average number of days that shipping trucks are taking to deliver a pallet from the distributor’s warehouse to the retail store? Hint: On a sheet named “Question 5,” create two separate pivot tables with EPC Read and Tag Read Date and Time. For both pivot tables, filter by “Type of Interaction”. For the first pivot table, filter by “Pallet loaded on a shipping truck” and select MAX of Tag Read Date and Time. For the second pivot table, filter by “Pallet delivered to and stored in the retail store” and select MIN of Tag Read Date and Time. Now subtract the two times in the two pivot tables to obtain the total days it takes shipping trucks to deliver product form warehouse to the retail store. Now take the average of these days.
Are some types of pallets (types of products) getting delivered quicker to the retail stores from the distributor’s warehouses? HINT: Copy the worksheet in Question 5 as a new worksheet. Add Product name to the pivot tables. Group the the times by product names and take average of times for each product name.
What is the average number of days that a pallet is spending in our manufacturing facilities before it is picked up by a shipping truck? Hint: On a sheet named “Question 7”, create two separate pivot tables with EPC Read and Tag Read Date and Time. For both pivot tables, filter by “Type of Interaction”. For the first pivot table, filter by “Pallet stored in the storage area” and select MAX of Tag Read Date and Time. For the second pivot table, filter by “Pallet loaded on a shipping truck” and select MIN of Tag Read Date and Time. Now subtract the two times in the two pivot tables to obtain the total days product is spending in the manufacturing facility. Now take the average of these days.
What is the average number of days that a pallet is spending in transit between locations? Hint: Add the answers for average time you computed in Question 4 and Question 5.
Between 1/3/2019 and 1/9/2019 (both inclusive), which pallets have recorded activities and what are these activities by pallet?

Review the Tax Communication Ordinary Expense Assignment.Download Tax Communication Ordinary Expense Assignment.
Use the fact pattern and resources provided to prepare a client memo. You do not need to do any additional research. The research materials provided in the file are enough to answer the prepare the client letter.
I have attached a client letter example we were given.

Please see attached for instructions.
I am providing you will all the paperwork and I just need the excel spreadsheet to be completed based on the last page strategy on the powerpoint presentation and other financials from PNC and Truist. My bank is PNC where I am trying to move improve their non-interest revenue.

accounting Career Exploration Assignment
Instructions
Overview: This assignment aims to help you explore potential career paths in accounting. While you may not be considering a career in accounting, you need to understand accounting roles as you may be working with accountants. You will research different types of accounting careers, analyze job responsibilities, and evaluate the education and experience requirements for each role.
Instructions:
Research different types of accounting careers: Use resources such as the Bureau of Labor Statistics, professional organizations like the American Institute of Certified Public Accountants (AICPA), and job postings to research different types of accounting careers. Examples may include public accounting, corporate accounting, government accounting, forensic accounting, or taxation.
Analyze job responsibilities: Select at least three accounting careers that interest you and analyze the job responsibilities for each. Describe the daily tasks, duties, and functions performed in each role. Consider the level of client interaction, degree of specialization, and potential for upward mobility in each role.
Evaluate education and experience requirements: Research the education and experience requirements for each of the accounting careers you have analyzed. Compare and contrast the different levels of education and experience needed for each role and identify any certifications or licenses that are required or recommended.
Reflect on your findings: Write a reflection on your research and analysis. Consider which accounting careers appeal to you the most and why. Evaluate how your skills, interests, and values align with each role’s job responsibilities and requirements. Consider any potential challenges or obstacles you may face in pursuing a career in accounting.
Format and submit your assignment: Your assignment should be typed, single-spaced with double-spacing between paragraphs, and at least two pages long. Use APA style for in-text citations and reference list. Submit your completed assignment to your instructor by the assigned due date.
Grading Criteria: Your assignment will be graded on the following criteria:
Thoroughness of research and analysis (40%)
Accuracy of information and use of sources (20%)
Reflection and critical thinking (30%)
Formatting and presentation (10%)
Hide Rubrics
Rubric Name: Accounting Career Exploration Assignment
Criteria
Excellent
Very Good
Good
Poor
Did Not Complete
Criterion Score
Thoroughness of research and analysis
2.5 points
Student identifies and analyzes at least three different accounting careers and provides detailed descriiptions of job responsibilities, potential for upward mobility, and specialization.
2.25 points
Student identifies and analyzes at least two different accounting careers and provides clear descriiptions of job responsibilities and potential for upward mobility.
2 points
Student identifies and analyzes at least two different accounting careers and provides clear descriiptions of job responsibilities and potential for upward mobility.
1.5 points
Student fails to identify or analyze any accounting careers.
0 points
No submission or incomplete submission.
Score of Thoroughness of research and analysis,/ 2.5
Reflection and critical thinking
1.5 points
Student provides a thoughtful reflection on their research, considering personal skills, interests, and values in relation to potential accounting careers. Student shows evidence of critical thinking and analysis.
1.35 points
Student provides a reflection on their research, considering personal skills, interests, and values in relation to potential accounting careers. Student shows some evidence of critical thinking and analysis.
1.2 points
Student provides a limited reflection on their research, with limited consideration of personal skills, interests, and values in relation to potential accounting careers. Student shows limited evidence of critical thinking and analysis.
0.9 points
Student provides no reflection on their research and shows no evidence of critical thinking and analysis.
0 points
No submission or incomplete submission.
Score of Reflection and critical thinking,/ 1.5
Accuracy of information and use of sources
1 point
Student accurately identifies and cites sources for all information presented.
0.8 points
Student accurately identifies and cites sources for most information presented.
0.7 points
Student inaccurately identifies or fails to cite sources for some information presented.
0.6 points
Student inaccurately identifies or fails to cite sources for most information presented.
0 points
No submission or incomplete submission.
Score of Accuracy of information and use of sources,/ 1
Total
Score of Accounting Career Exploration Assignment,/ 5
Overall Score
Excellent
4.5 points minimum
This score represents the average evaluation across all rubric criteria.
Very Good
4 points minimum
This score represents the average evaluation across all rubric criteria.
Good
3.5 points minimum
This score represents the average evaluation across all rubric criteria.
Satisfactory
3 points minimum
This score represents the average evaluation across all rubric criteria.
Poor
2.8 points minimum
This score represents the average evaluation across all rubric criteria.
0 Points
0 points minimum
This score represents the average evaluation across all rubric criteria.