$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket?
Book Your Assignment at The Lowest Price
Now!
Students Who Viewed This Also Studied
ACCT 2031 Managerial Accounting
Task
This is a managerial accounting case study that needs to be solved
The steps you will follow for this project are as follows:
1) Review the video and/or the scripted PDF’s for Windows.
2) Download the Excel data file. (After you download the file, You need to save your assignment by clicking the save button in the upper right hand corner before you exist. If you do not save your assignment, the next time you enter, you may see a different company and set of data.)
3) Perform the te_quirements on the data file using the video or pdfs.
4) Check your work in the Excel file with these check figures.
5) Use your Excel file to answer the six multiple choice questions below. (You will have to scroll down to see all of the questions.)
Resources
A) Information on how to update Excel and Office 365.
B) If you do not have Office 365, click here to learn how to get it for free.
C) Information on data column headinga.
D) Information on addtional data column heading2.
E) Troubleshooting FAQ.
This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not proceed with answering the questions until you have asked for assistance from your instructor.
1. Using the data worksheet for Requirement 1 in Kitchen Life, what is the contribution margin for customer number 291137 on 1 / 18 / 2015? (To find customer 291137 in Excel. in the Home ribbon, click on Find & Select and choose the option to Find.)
B. $1,982.40
C. $3.906.98
D. $1.331.71
2. Using the pivot table you created for Requirement 2 in Kitchen Life, what were total sales in Quarter 1, 2017 for the International region?
A. $296,800.27
B. $501,596.76
C. $509,323.26
D. $614,314.20
3. Using the pivot table you created for Requirement 3 in Kitchen Life, what was the contribution margin for the Gulf Coast region in 2015?
A. $6,987,241.54
B. $4,569,689.88
C. $5,054,947.82
D. $7,520,767.75
4. Using the pivot table you created for Requirement 4 in Kitchen Life, what was the most profitable brand in 2018. as measured by contribution margin?
A. Au Courant
B. Classique
5. Using the pivot table you created for Requirement 5 in Kitchen Life, what was the most profitable collection in 2018. for the Classique brand as measured by the contribution margin ratio?
A. Syracuse
B. Key West CI
C. Rochester
D. Aiden
6. Using the data set for requirement 6 in Kitchen Life, what was the segment margin for the Pacific Northwest region?
A. $185,500
B. $7,119,819
C. $3.911,361
D. $2,360,899
7. Using the pivot tab* you created for Requirement 1 for Sunnyview. what was the total spending for Sunnyview m 2016?
A. $174,122,819
B. 5183.982.129
C. 8137.943,091
D. $158,558,916
8. Using the pivot table you created for Requirement 2 for Surnyview. how much was spent in General Government in 2016?
A. 8102,348.273
B. $119.277,143
C. $33.898.066
D. $21,147.610
9. Using the pivot table you created for Requirement 2 for Surnyview. how much was spent in Pubic Works in 2018?
A. 621,147.610
B. $41,283.065
C. $119,277,143
D. $33.1398.088
10. Using the pivot tab* you created Mr Requirement 3 for Sunnyview. how much was supplies expense in 201137
A. 819.387
B. 823,581
C. 800,391
D. 816,885.990
11. Using the budgeted worksheet results from requirement 4 for Sunnyvew, what was the variance expressed as a percentage Mr bonds and debt – related expeditures?
A. -1.50%
B. -15.40%
C. -6.32%
D. -3.44%
12. Ming the budgeted worksheet results from requirement 4 for Sunnyvew, how many variances had a yellow Mangle?
A. None
B. 9
C.8
D.7
ACCT 2031 Managerial Accounting
Answer in Detail
Solved by qualified expert
Get Access to This Answer
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.
Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.
Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.
Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.
29 More Pages to Come in This Document. Get access to the complete answer.
More ACCT2031 ACCT 2031 Managerial Accounting: Questions & Answers
Idea of the Social Contract
The social contract in accounting The idea of the social contract is an ancient one—it predates the European Enlightenment (which is generally thought to have started in the late 17th century). Although its origin is unknown, its greatest proponents actually bookended the Enlightenment period: …
View Answer
Business combination
100 word short essy about the nature of business combination and required disclosures including referencing .. …
View Answer
Business Management
Required (HI6025 ) T2, 2016 Marks 1) Structure & References 20 2) Management Summary/Abstract/Introduction 20 3) Discuss the nature and value to society of the research being done by BSF Ltd. 20 4) Discuss the problems with the early the research done by BSF Ltd. 20 5) Define and discuss the nat …
View Answer
Management
Based on the information provided above, identify and calculate the principal ratios that a financial analyst might use that would give some indication of the following: a. the entity’s earning ability; (4 ratios are required)b. the extent to which internal sources have been u …
View Answer
Content Removal Request
If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the
content removal request.
Choose Our Best Expert to Help You
Ethan Stout
PhD in English with specialization in Feminist Theory and Medieval Literature
662 – Completed Orders
Hire Me
Haidil Jiang
PhD in Law with Specialization in Civil Law and Aviation Law
1047 – Completed Orders
Hire Me
Monica Shannon
I have received my Master’s in Psychology from James Cook University in Singapore.
800 – Completed Orders
Hire Me
Still in Two Minds? The Proof is in Numbers!
33845 Genuine Reviews With a Rating of 4.9/5.
Biology
Assignment: 1 Page, Deadline:
5 days
Great work thank you, I am grateful The response was quick, the effort was great, You can see the person put effort and time. I would recommend again
User ID: 8***94 Ireland
Management
Thesis: 6.4 Pages, Deadline:
2 days
great work fast reply easy and understanding contenti am working with you for 1 year and you keep helping me diploma and now PhD
User ID: 4***28 Doha, Qatar
Psychology
Home Work: 2.4 Pages, Deadline:
2 hours
I was able to receive help in less than 3 hours!! Such good customer service!! Well written and made sense!
User ID: 8***08 United States
Healthcare
Essay: 8 Pages, Deadline:
6 days
Highly recomended. With a good explanation and elaboration. They Alyways help and will do the best for the task.
User ID: 7***74 Malaysia
Psychology
Assignment: 4 Pages, Deadline:
9 days
I look forward to receiving a good grade for the following assignment. Thank you for your assistance.
User ID: 7***29 Australia
Assignment
Thesis: 3.6 Pages, Deadline:
4 days
thanks for the assistance of my assignment. I look forwards to getting the final results.
User ID: 7***29 Australia
Economics
Programming: 6 Pages, Deadline:
12 days
Thank you so much for your support. The answers were related and hopefully will attract the doctor to give me a grade.
User ID: 5***87 Jeddah, Saudi Arabia
English
Essay: 1 Page, Deadline:
14 days
Language is my weakness. But I got help from you and that made it easy to get marks that i want.
User ID: 8***70 Canada
English
Essay: 0.8 Pages, Deadline:
4 days
I really appreciate the work that you have done for me. I got passing mark only because of you guys.
User ID: 8***70 Canada
Assignment
Assignment: 4 Pages, Deadline:
5 days
My assignment helper is so amazing, she did my work before my requirement dead line.
User ID: 8***98 United States
Biology
Assignment: 1 Page, Deadline:
5 days
Great work thank you, I am grateful The response was quick, the effort was great, You can see the person put effort and time. I would recommend again
User ID: 8***94 Ireland
Management
Thesis: 6.4 Pages, Deadline:
2 days
great work fast reply easy and understanding contenti am working with you for 1 year and you keep helping me diploma and now PhD
User ID: 4***28 Doha, Qatar
Psychology
Home Work: 2.4 Pages, Deadline:
2 hours
I was able to receive help in less than 3 hours!! Such good customer service!! Well written and made sense!
User ID: 8***08 United States
Healthcare
Essay: 8 Pages, Deadline:
6 days
Highly recomended. With a good explanation and elaboration. They Alyways help and will do the best for the task.
User ID: 7***74 Malaysia
Psychology
Assignment: 4 Pages, Deadline:
9 days
I look forward to receiving a good grade for the following assignment. Thank you for your assistance.
User ID: 7***29 Australia
Assignment
Thesis: 3.6 Pages, Deadline:
4 days
thanks for the assistance of my assignment. I look forwards to getting the final results.
User ID: 7***29 Australia
Economics
Programming: 6 Pages, Deadline:
12 days
Thank you so much for your support. The answers were related and hopefully will attract the doctor to give me a grade.
User ID: 5***87 Jeddah, Saudi Arabia
English
Essay: 1 Page, Deadline:
14 days
Language is my weakness. But I got help from you and that made it easy to get marks that i want.
User ID: 8***70 Canada
English
Essay: 0.8 Pages, Deadline:
4 days
I really appreciate the work that you have done for me. I got passing mark only because of you guys.
User ID: 8***70 Canada
Assignment
Assignment: 4 Pages, Deadline:
5 days
My assignment helper is so amazing, she did my work before my requirement dead line.
User ID: 8***98 United States