Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Managerial Accounting – Using Microsoft Excel only

Description

Original text, no plagiarism.

Complete the questions using Microsoft Excel. No other submission format is allowed.

Textbook:

Warren, C. S., & Tayler, W. B. (2020). Managerial accounting (15th ed). Cengage.

Print: ISBN: 9781337912020

eText ISBN: 9780357685709

Complete the following questions using Microsoft Excel. No other submission format is allowed. Review the grading rubric to confirm you are
meeting the assignment requirements.
Consider the following information for Hamburg Corporation:
Items
Beginning inventory
Units started during the year
Ending inventory
Inventory is 100% complete as to materials and 60% complete as to conversion.
Items
Materials
Beginning costs (SAR)
425,000
Costs added during the period (SAR)
1,255,000

Units
85,000
155,000
61,000

Conversion
686,000
980,000

Using the WEIGHTED AVERAGE method:
1. Calculate the number of units completed during the period.
2. Calculate equivalent units for conversion during the period.
3. Calculate cost per equivalent units for materials.

Mannheim Corporation manufactures small camping tents and family camping tents. The estimated direct labor time to produce each type of tent
is as follows:
Items
Small
Family
Estimated tents produced
24,500
11,000
Direct labor hours per tent
2.5
4.5
Estimated overhead for the period = 1,300,000 SAR.
1. Compute the overhead cost assigned to each type of tent assuming direct labor hours are used to allocate overhead costs.

The controller is not satisfied with the traditional method of allocating overhead because he believes that most of the overhead costs relate to the
family tent product line because of its complexity. He, therefore, developed the following three activity cost pools and related cost drivers to
better understand the costs.
Activity Cost Pools
Expected Use of Cost Drivers
Estimated Overhead Costs (SAR)
Setting up machines
1,000 setups
25,000
Assembling
90,000 labor hours
980,000
Inspection
1,200 inspections
230,000
1. Calculate the activity-based overhead rates for these three cost pools.
2. Compute the cost that is assigned to each tent using activity-based costing system, given the following information.

Expected Use of Cost Drivers per Product
Items
Number of setups
Direct labor hours
Number of inspections

Small
130
29,000
125

1. What do you believe the controller should do and why?

You must show your work for credit.

Family
825
55,000
1,125

Purchase answer to see full
attachment

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Management Question

Description NO COPING ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 MGT101 (1st Term 2025-2026) Deadline: 04/10/2025 @ 23:59 (To be released to students on BB in Week 2) Course Name: Principles

Management Question

Description NOO COPING ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Decision Making and Problem Solving (MGT 312) Due Date: End of Week 5, 4-10-2025 Course Name: Decision Making and Problem Student’s

it 353 dis 1

Description see Discussion Board 1 Purpose In this discussion board, you will post your answer to the question. You will also read and respond to other classmates’ postings. This is an excellent way for you to interact with your colleagues and to share your thoughts about the question answer in

CT – Module 04: Networks, Collaborative Technology, and the Internet of Things

Description CT – Module 04: Networks, Collaborative Technology, and the Internet of Things In this module, we examine the importance of networks to communication and sharing information. We will explore network basics that managers should understand in order to make effective decisions on network-related investments. We will also cover some

to answer the assigment

Description please follow all guidlines and requirements to answer the assigment College of Administration and Finance Sciences Assignment (1) Deadline: Saturday 04/10/2025 @ 23:59 Course Name: Cost Accounting Student’s Name: Course Code: ACCT 301 Student’s ID Number: Semester: First CRN: 14455 Academic Year: 1447 H (2025-26) For Instructor’s Use only

to answert the assigment

Description please follow all requirement and guidlines to answer the assigmnt ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Decision Making and Problem Solving (MGT 312) Due Date: End of Week 5,

Logistics Management /MGT322

Description CAREFULLY • THE ASSIGNMENT MUST BE SUBMITTED ON BLACKBOARD (WORD FORMAT ONLY) VIA ALLOCATED FOLDER. • ASSIGNMENTS SUBMITTED THROUGH EMAIL WILL NOT BE ACCEPTED. • STUDENTS ARE ADVISED TO MAKE THEIR WORK CLEAR AND WELL PRESENTED,MARKS MAY BE REDUCED FOR POOR PRESENTATION. THIS INCLUDES FILLING YOUR INFORMATION ON THE

Project Management (MGT 323)

Description The Assignment must be submitted on Blackboard (WORD format only) via allocated folder. Assignments submitted through email will not be accepted. Students are advised to make their work clear and well presented, marks may be reduced for poor presentation. This includes filling your information on the cover page. Students

hcm 520 model 3 master

Description For this week’s discussion, respond to the following in your initial post: Using the Saudi Digital Library, locate and read three scholarly research articles regarding research, statistical methods, and specific tools healthcare (e.g., flowcharts, cause-and-effect diagrams, Pareto charts, and run charts) used in quality measurement and improvement in the

Writing Question

Description Assignment-I: Topic Selection & Research Questions (15 points) A topic of research should be chosen. It can be either a research paper or a startup concept. Once the topic is finalized, the research questions (based on which objectives of the study will be formed) must be developed (not more

Finance Question

Description Financial Analysis Financial analysis can be defined as the process of assessing the financial condition of a firm. It can be very useful in understanding the financial position of a company. There are varieties of ratios that can be used for this purpose but each has it benefits and

Management Question

Description (( PLEASE USE YOUR OWN WORDS AND WRITE THE REFERENCE)) (( PLEASE CHECK THE ATTACHED FILE AND FOLLOW THE INSTRUCTIONS CAREFULLY )) (( PLEASE NO PLAGIARISM )) (( Please use APA 7th edition )) ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education

Business Question

Description (( PLEASE USE YOUR OWN WORDS AND WRITE THE REFERENCE)) (( PLEASE CHECK THE ATTACHED FILE AND FOLLOW THE INSTRUCTIONS CAREFULLY )) (( PLEASE NO PLAGIARISM )) (( Please use APA 7th edition )) ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education

Business Question

Description Contents Topic selection Brainstorm Questions Tip: Keywords Finding Topic Ideas Online Read Background Information Keywords are the main terms that describe your research question or topic. Keep track of these words so you can use them when searching for books and articles. Identify the main concepts in your research

Finance Question

Description Finance Principles for this module: Principle 1: Cash Flow Is What Matters— We are concerned with the money in hand, not accounting profit. Principle 5: Conflicts of Interest Cause Agency Problems-Conflicts of interest between owners and managers can create challenges for optimal efficiency and value creation in organizations. Learning

Management Question

Description Please follow the : General Instructions – PLEASE READ THEM CAREFULLY Avoid plagiarism ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Public Management (MGT 324) Due Date: 18.10.2025 @ 23:59 Course

Management Question

Description Colquitt LePine Wesson Organizational Behavior Improving Performance and Commitment in the Workplace Seventh Edition JASON A. COLQUITT University of Notre Dame JEFFERY A. LEPINE Arizona State University MICHAEL J. WESSON Auburn University Final PDF to printer ORGANIZATIONAL BEHAVIOR Published by McGraw-Hill Education, 2 Penn Plaza, New York, NY 10121.

Management Question

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Decision Making and Problem Solving (MGT 312) Due Date: End of Week 5, 4-10-2025 Course Name: Decision Making and Problem Student’s Name: Solving