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

Ass , 361

Description All required tasks are included in the file. College of Health Sciences Department of Public Health ASSIGNMENT COVER SHEET Course name: Fundamentals of Safety Course number: PHC 361 CRN: Paper Assignment Assignment title or task: (You can write a question) 1. What is the difference between Risk and Hazard?

500 dis 11

Description Examine the quality metrics, access, and health care insurance of the German healthcare system. Compare each of these three points to health care services in Saudi Arabia. Explain the different ways and methods that these particular healthcare systems are alike and different. Embed course material concepts, principles, and theories

312 ass 16

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

Databases Question

Description hey, i just need solving for my assignment with following the rules properly. THANKS! College of Computing and Informatics Assignment 2 Deadline: Monday 10/11/2025 @ 23:59 [Total Mark for this Assignment is 8] Student Details: Name: ### ID: ### CRN: ### Instructions: • You must submit two separate copies

316 PRE 2

Description Telemedicine: current and future College of Health Sciences Department of Health Informatics HCI-316 – Group Presentation In this group project, teams of 3–5 students will collaborate to explore and present exciting developments in digital health innovation within the Middle East, with a particular focus on Saudi Arabia (KSA). The

515 CT 12

Description Medical Malpractice (110 points) Create a PowerPoint presentation detailing the standard operating procedure in dealing with “near misses” in your facility. Be sure to address the following issues: Examine any applicable rules and regulations pertaining to malpractice in the Kingdom of Saudi Arabia. Detail a specific procedure in dealing

Corporate Finance / 201

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

Project 475-4

Description see College of Computing and Informatics Project Deadline: Sunday 30/11/2025 @ 23:59 [Total Mark for this Project is 14] Group Details: Name: Name: Name: Name: CRN: ID: ID: ID: ID: Instructions: • You must submit two separate copies (one Word file and one PDF file) using the Assignment Template

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 Assignment MGT311 ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 3 Logistics Management (MGT 322) Due Date: 06/12/2025 @ 23:59 Course Name: Student’s Name: Course Code: MGT322 Student’s ID Number: Semester: First

Management Question

Description General Instructions – PLEASE READ THEM CAREFULLY The Assignment must be submitted on (WORD format only) via allocated folder. 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

Management Question

Description assignment mgt 311 ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University Department of Business Administration College of Administrative and Financial Sciences Assignment 3 Introduction to operations Management (MGT 311) Due Date: 6th December 2025 @ 23:59 Course Name: Introduction

Management Question

Description General Instructions – PLEASE READ THEM CAREFULLY The Assignment must be submitted on (WORD format only) via allocated folder. 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

Management Question

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University Department of Business Administration College of Administrative and Financial Sciences Assignment 3 Introduction to operations Management (MGT 311) Due Date: 6th December 2025 @ 23:59 Course Name: Introduction to Operations Management

MGT530 M11-Discussion Forum: Lean Operations and Scheduling

Description I need help completing a discussion board post for my Management course (Operation Management). Below are the exact requirements provided by my instructor: Description: In this module, you will learn about lean operations and how lean can relate to a successful implementation of operations management within an organization or

econ mo solve word and ppt

Description Assignment Activity What are the main causes of Unemployment? Do you agree that technological up-gradation in any industry may cause unemployment in that industry? Provide your opinion with one example. Total grade: 20 marks. Distribution: 10 marks for the written report + 10 marks for the presentation and discussion.

Computer Science Question

Description see College of Computing and Informatics Assignment 2 Deadline: Tuesday 10/11/2025 @ 23:59 [Total Mark for this Assignment is 8] Student Details: Name: ### ID: ### CRN: ### Instructions: • You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard

Management Question

Description General Instructions – PLEASE READ THEM CAREFULLY The Assignment must be submitted on (WORD format only) via allocated folder. 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