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

515 model 1-12

Description Unique Aspects of Health Services & Financial Management There are a number of unique factors relating to the health services sector: Services are provided by both not-for-profit (or nonprofit) organizations that can be either governmental or private and for-profit organizations that are private The majority of payments made to

510 CT 12

Description Population Health in Saudi Arabia (110 points) Leaders must stay abreast of healthcare trends in order to best serve the population they are supporting. In recent decades, disease threats in Saudi Arabia have shifted from communicable diseases to non-communicable diseases. The high prevalence of unhealthy lifestyles and cardiovascular disease

510 CT 15

Description opulation Health in Saudi Arabia (110 points) Leaders must stay abreast of healthcare trends in order to best serve the population they are supporting. In recent decades, disease threats in Saudi Arabia have shifted from communicable diseases to non-communicable diseases. The high prevalence of unhealthy lifestyles and cardiovascular disease

505 MODEL 1-16

Description As you have learned this week, there are numerous topics students can choose from to perform research in quality and patient safety research. For example, the increased reinfection rates are a growing concern in Saudi Arabia and globally across western nations. Analyze how your potential research project in this

Management Question

Description NO COPING ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University Department of Business Administration College of Administrative and Financial Sciences Assignment 1 Due Date: 28th February 2026 @ 23:59 Course Name: Marketing Management Student’s Name: Course Code: MGT201 Student’s

Business Question

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

Management Question

Description Assgiment MGT321 ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Introduction to International Business (MGT 321) Due Date: 28/02/2026 @ 23:59 Course Name: Introduction to International Business Course Code: MGT-321 Student’s

mgt404 , Organization Design and develop

Description General Instructions – PLEASE READ THEM 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

112 ACT 1

Description Describe the difference between EHR and EMR? provide an example? 2 REFERANCES

505 DIS 2-1

Description Locate a research study that utilized experimental or quasi-experimental methods. Briefly summarize the study. For example, discuss the inclusion of 2-group tests, regression analysis, and time-series analysis in terms of the study design’s strengths, weaknesses, or limitations. What challenges or limitations did the researcher identify they encountered by choosing

505 DIS 2-2

Description Locate a research study that utilized experimental or quasi-experimental methods. Briefly summarize the study. For example, discuss the inclusion of 2-group tests, regression analysis, and time-series analysis in terms of the study design’s strengths, weaknesses, or limitations. What challenges or limitations did the researcher identify they encountered by choosing

505 DIS 2-3

Description Locate a research study that utilized experimental or quasi-experimental methods. Briefly summarize the study. For example, discuss the inclusion of 2-group tests, regression analysis, and time-series analysis in terms of the study design’s strengths, weaknesses, or limitations. What challenges or limitations did the researcher identify they encountered by choosing

505 DIS 2-4

Description Locate a research study that utilized experimental or quasi-experimental methods. Briefly summarize the study. For example, discuss the inclusion of 2-group tests, regression analysis, and time-series analysis in terms of the study design’s strengths, weaknesses, or limitations. What challenges or limitations did the researcher identify they encountered by choosing

505 DIS 2-5

Description Locate a research study that utilized experimental or quasi-experimental methods. Briefly summarize the study. For example, discuss the inclusion of 2-group tests, regression analysis, and time-series analysis in terms of the study design’s strengths, weaknesses, or limitations. What challenges or limitations did the researcher identify they encountered by choosing

505 DIS 2-6

Description Locate a research study that utilized experimental or quasi-experimental methods. Briefly summarize the study. For example, discuss the inclusion of 2-group tests, regression analysis, and time-series analysis in terms of the study design’s strengths, weaknesses, or limitations. What challenges or limitations did the researcher identify they encountered by choosing

505 DIS 2-7

Description Locate a research study that utilized experimental or quasi-experimental methods. Briefly summarize the study. For example, discuss the inclusion of 2-group tests, regression analysis, and time-series analysis in terms of the study design’s strengths, weaknesses, or limitations. What challenges or limitations did the researcher identify they encountered by choosing

505 DIS 2-8

Description Locate a research study that utilized experimental or quasi-experimental methods. Briefly summarize the study. For example, discuss the inclusion of 2-group tests, regression analysis, and time-series analysis in terms of the study design’s strengths, weaknesses, or limitations. What challenges or limitations did the researcher identify they encountered by choosing

505 DIS 2-9

Description Locate a research study that utilized experimental or quasi-experimental methods. Briefly summarize the study. For example, discuss the inclusion of 2-group tests, regression analysis, and time-series analysis in terms of the study design’s strengths, weaknesses, or limitations. What challenges or limitations did the researcher identify they encountered by choosing