Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Account Project

make an entry on an excel sheet and answer some questions

ACCT Project/Screenshot 2024-11-26 at 1.21.08 PM.png

__MACOSX/ACCT Project/._Screenshot 2024-11-26 at 1.21.08 PM.png

ACCT Project/Chapter_8_Applying_Excel_Student_Form.xls

Chapter 8 Form

Chapter 8: Applying Excel
Data Year 2 Quarter Year 3 Quarter
1 2 3 4 1 2
Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000
• Selling price per unit $8 per unit
• Accounts receivable, beginning balance $65,000
• Sales collected in the quarter sales are made 75%
• Sales collected in the quarter after sales are made 25%
• Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter
• Finished goods inventory, beginning 12,000 units
• Raw materials required to produce one unit 5 pounds
• Desired ending inventory of raw materials is 10% of the next quarter’s production needs
• Raw materials inventory, beginning 23,000 pounds
• Raw material costs $0.80 per pound
• Raw materials purchases are paid 60% in the quarter the purchases are made
and 40% in the quarter following purchase
• Accounts payable for raw materials, beginning balance $81,500
Enter a formula into each of the cells marked with a ? below
Review Problem: Budget Schedules
Construct the sales budget Year 2 Quarter Year 3 Quarter
1 2 3 4 1 2
Budgeted unit sales ? ? ? ? ? ?
Selling price per unit ? ? ? ? ? ?
Total sales ? ? ? ? ? ?
Construct the schedule of expected cash collections Year 2 Quarter
1 2 3 4 Year
Accounts receivable, beginning balance ? ?
First-quarter sales ? ? ?
Second-quarter sales ? ? ?
Third-quarter sales ? ? ?
Fourth-quarter sales ? ?
Total cash collections ? ? ? ? ?
Construct the production budget Year 2 Quarter Year 3 Quarter
1 2 3 4 Year 1 2
Budgeted unit sales ? ? ? ? ? ? ?
Add desired finished goods inventory ? ? ? ? ? ?
Total needs ? ? ? ? ? ?
Less beginning inventory ? ? ? ? ? ?
Required production ? ? ? ? ? ?
Construct the raw materials purchases budget Year 2 Quarter Year 3 Quarter
1 2 3 4 Year 1
Required production (units) ? ? ? ? ? ?
Raw materials required to produce one unit ? ? ? ? ? ?
Production needs (pounds) ? ? ? ? ? ?
Add desired ending inventory of raw materials (pounds) ? ? ? ? ?
Total needs (pounds) ? ? ? ? ?
Less beginning inventory of raw materials (pounds) ? ? ? ? ?
Raw materials to be purchased ? ? ? ? ?
Cost of raw materials per pound ? ? ? ? ?
Cost of raw materials to be purchased ? ? ? ? ?
Construct the schedule of expected cash payments Year 2 Quarter
1 2 3 4 Year
Accounts payable, beginning balance ? ?
First-quarter purchases ? ? ?
Second-quarter purchases ? ? ?
Third-quarter purchases ? ? ?
Fourth-quarter purchases ? ?
Total cash disbursements ? ? ? ? ?
&F
Page &P

__MACOSX/ACCT Project/._Chapter_8_Applying_Excel_Student_Form.xls

ACCT Project/Screenshot 2024-11-26 at 1.22.22 PM.png

__MACOSX/ACCT Project/._Screenshot 2024-11-26 at 1.22.22 PM.png

ACCT Project/Screenshot 2024-11-26 at 1.22.34 PM.png

__MACOSX/ACCT Project/._Screenshot 2024-11-26 at 1.22.34 PM.png

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Mgmt 338 RP

I’ll post question to you  Assignment Expectations Week 1: Country Selection Students are required to select a country to research for the final paper. The selected country must be claimed in the ‘Country Selection’ discussion topic located in the open forum. Students must review classmates’ selections to ensure their chosen

Business Finance – Management Homework

MBA 599 – Strategic Management Case Project This capstone course requires each student to construct a detailed and well-thought-out analysis of a business employing all the relevant strategic analysis tools studied in the course. This project will take the full term to complete. It is our sincere hope that you

Mapping the Customer Experience Journey to Improve Customer Experience

Mapping the Customer Experience Journey to Improve Customer Experience In today’s competitive market, businesses must focus on delivering meaningful and seamless interactions at every stage of engagement. This is why mapping the customer experience journey has become an essential strategy for growth. By understanding how customers interact with a brand

Generative AI

   Discuss whether and how generative AI will play a role in strategic planning? How might you use it to assist in strategy formulation and implementation?

BCG and IE

   Are there key differences between BCG and IE portfolio matrices in both early-stage and established companies? If so, what are those key differences, and if not, why not? Provide insights in your responses based on the industry in which you have worked, are working in, or would like to

Event Software LLC

Reliable virtual event software is essential for online gatherings, and Eventsoftware.com offers seamless integrations, engagement features, and stable performance for global audiences.

Logistics 6

Please see attached  BUSI 615 Integrated Learning Project Assignment Instructions Overview The integrated learning assignment is a series of 6 assignments and a final course consolidated submission. All assignments and the compilation of the final consolidated submission is managed as an individual assignment. Purpose The purpose of the ILP is

Total Quality Management week 6

See attached the problem for my organization is invoice processing and how long it takes for vendors to get paid for the cook county organization. 

BUSINESS( NO PLAGARISM A+ WORK, ON TIME)

Tutor discussions  DB (NO MORE THAN 150 WORDS) Hello class! Looks like we made it to the end! When a company like X5RL creates a breakthrough treatment, the question of whether people can afford it gets complicated fast. Technically, the public’s financial struggles aren’t X5RL’s “problem,” but it’s hard to

Week 7 discussion

 please be sure to discuss the following 4 prompts regarding ‘The Three R’s’ (reduce, reuse, recycle) to waste reduction. (1) Please describe how ‘The Three R’s’ are ordered by how impactful those actions are. (2) Given the issues with recycling, why do you think it is still included in being

DEFM200

see attached Instructions Assignment Directions Write a three-page essay (excluding title and reference pages) on contract modifications and terminations in government contracting, using paraphrased content from at least three library articles and APA citations as detailed in the current APA manual in the library resources focus on: · The types and

Management

Can you help me with this question? Essay 2 Assignment Preparation Instructions: 1. Compose the assignment using Microsoft Word. 2. The paper should be formatted using double-spaced, Times New Roman, 12-point font, and one-inch margins. Content Instructions: 1. Pick a topic of interest to you from Chapters 7-12 of your

Calculating Quantities and Annual Costs

Assignment with questions are attached. Answers can be used on same document QSO 630 Module Four Problem Set Calculating Quantities and Annual Costs For this assignment, you will calculate quantities and annual costs to answer two supply chain questions. When you are finished, submit your answers for review by your

EXP 4

I have attached the completed versions of A2 and A3. Please use both to complete A4. The assignment needs to be cohesive to my original a2 and a3. This assignment is graded HARSHLY. I need quality work only 

Deliverable 2 – Lease Versus Purchase

  Scenario Health resources are finite. Therefore, it is incumbent on all health organizations to exercise responsible fiscal decision making when allocating their financial resources. As the senior cost analyst for a local, nonprofit hospital, you are charged with determining the most appropriate use of financial resources and making recommendations.

Deliverable 2 – Assessing Data Sets for Population Health Management

  Scenario W. Edwards Deming, who many consider the father of quality management, espoused the importance of using data for decision making. As a healthcare leader responsible for managing your healthcare organization’s population health management program, you will find that relevant, accurate, and current population health data is an essential