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 Learning Goal: I’m working on a management multi-part question and need support to help me learn. 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 must mention question number clearly

Management Question

Description Instructions – PLEASE READ THEM CAREFULLY ● This assignment is an individual assignment. ● The Assignment must be submitted only in WORD formatvia the allocated folder. ● Assignments submitted through email will not be accepted. ● Students are advised to make their work clear and well-presented; marks may be

Management Question

Description Learning Goal: I’m working on a management multi-part question and need support to help me learn. 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 must mention question number clearly

Management Question

Description Learning Goal: I’m working on a management multi-part question and need support to help me learn. 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 must mention question number clearly

Management Question

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

Communication Management (MGT421)

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 BE REDUCED FOR POOR PRESENTATION.

Project245-1

Description see College of Computing and Informatics Project Deadline: Tuesday 02/12/2025 @ 23:59 [Total Mark is 14] Student Details: CRN: Name: Name: Name: ID: ID: ID: Instructions: • You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated

Project 244-1

Description see College of Computing and Informatics Project Deadline: Thursday 04/12/2025 @ 23:59 [Total Mark is 14] Student Details: CRN: Name: Name: Name: ID: ID: ID: Instructions: • You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated

312 ass 9

Description see PHC 312 Group Assignment Paper College of Health Sciences ASSIGNMENT COVER SHEET Course name: Health Communications Course code: PHC312 CRN: Assignment title or task: Students enrolled in PHC 312 in first term 2025 will be divided into groups (3-5 students per group). The first section will be designed

Management Question

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Management of Technology (MGT 325) Due Date: 4th Oct @ 23:59 Course Name: Management of Technology Student’s Name: Course Code: MGT325 Student’s ID

MGT – 401 (Strategic Management)

Description Below are the conditions for completing the assignment. Additionally, there are further requirements inside the file that must be followed: -Make sure to avoid plagiarism as much as possible . -Use font Times New Roman , 12 font sizes. -Use 1.5 line spacing with adjust to all paragraphs (

Introduction to Operations Management (MGT 311)

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

Introduction to Operations Management (MGT311)

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

312 ass 8

Description see PHC 312 Group Assignment Paper College of Health Sciences ASSIGNMENT COVER SHEET Course name: Health Communications Course code: PHC312 CRN: Assignment title or task: Students enrolled in PHC 312 in first term 2025 will be divided into groups (3-5 students per group). The first section will be designed

Management Question

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Public Management (MGT 324) Due Date: 18th October 2025 @ 23:59 Course Name: Public Management Student’s Name: Course Code: MGT324 Student’s ID Number:

Management Question

Description These are three assignments for three different subjects. ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Strategic Management (MGT 401) Due Date: 04/10/2025 @ 23:59 Course Name: Strategic Management Student’s Name:

mgt325 ass1 – mgt325 ass2 – mgt421 – mgt401

Description # You should not copy from any website # References must be written # The assignment must be delivered on time # The agreed number of words must be adhered to # Give examples and write a perfect answer ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of

Public Management (MGT324)

Description CAREFULLY • THE ASSIGNMENT MUST BE SUBMITTED ON BLACKBOARD (WORD FORMAT ONLY) VIA THE 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 IN YOUR INFORMATION ON