Homework Answers
| Units Produced | Total Cost | |
| Jul | 18,000.00 | $ 32,000.00 |
| Aug | 32,000.00 | $ 48,000.00 |
| Sep. | 36,000.00 | $ 55,000.00 |
| Oct | 22,000.00 | $ 38,000.00 |
| Nov | 40,000.00 | $ 66,100.00 |
| Dec | 38,000.00 | $ 62,000.00 |
| Fixed cost (Intercept) | $ 4,836.29 | |
| Variable cost per unit (Slope) | $ 1.46 | Per unit |
| Cost Equation: | ||
| Y = $4836.26 + $1.46 x | ||
Add Answer to:
**This assignment MUST be completed in Excel using formulas and uploaded into Canvas for grading** BE5.13...
Complete the following questions using Microsoft Excel. No other submission format is allowed. Review the grading...
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. (All amounts in SAR except units.) Given the following information for Riyadh Corporation: Advertising costs 18,000 Administrative salaries 39,000 Delivery vehicle depreciation 12,000 Factory repair and maintenance 55,000 Indirect labor 48,000 Indirect materials 23,000 Manufacturing equipment depreciation 18,000 Office rent 24,000 President's salary 150,000 Sales revenue 1,000,000 Sales salary 120,000 Direct materials 140,000 Direct labor...
Preferably in excel form Part B: Calculate using Excel formulas, the NPV of each of the...
Preferably in excel form
Part B: Calculate using Excel formulas, the NPV of each of the 3 projects It is possible that ABC Company may not be able to advise ABC Company complete all 3 projects. Therefore, as to the order in which they should pursue the projects (i.e. which project should ABC Company attempt to do first, second, and last). Provide justification and analysis as to why you chose the order you did. The analysis must also be done...
IN A EXCEL FILE USING EXCEL FORMULAS AND CALCULATIONS MUST SHOE FORMULAS IN CELL! SHOW THE STEPS ...
IN A EXCEL FILE USING EXCEL FORMULAS AND CALCULATIONS MUST SHOE FORMULAS IN CELL! SHOW THE STEPS IN SOLUTION APPROACH. Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type...
MUST BE DONE ON EXCEL USING EXCEL FORMULAS 2. Using the trial balances data on the...
MUST BE DONE ON EXCEL USING
EXCEL FORMULAS
2. Using the trial balances data on the following page complete the following in Excel using two worksheets (Total 345 points): a. For worksheet 1: i. Enter the data as provided (36 pts) ii. Use the SUMO function to check your data entry, (12 pts) iii. Format the columns using appropriate formats ($ signs in first and last numbers in a column; numbers line up, commas for 000's, underlining of numbers only...
PLEASE HELP! The master budget must be completed using formulas. there must be a sales budget,...
PLEASE HELP! The master budget must be completed using formulas.
there must be a sales budget, production budget, Direct Materials
budget, Direct labor budget, manufacturing overhead budget, selling
and admin budget, budgeted income statement, Schedule of exp
collections, sch of exp payments, sch of exp payments DM, cash
budget, and budgeted balance sheet. please include the formulas you
used.
Purpose: The purpose of this project is to help you practice and reinforce the steps necessary to complete a Master Budget,...
Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have...
Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow: Month Machine Hours Electricity Costs January 3,500 $ 18,900 February 3,900 $ 22,000 March 2,900 $ 14,000 April 4,100 $ 24,000 May 4,800 $ 28,750 June 4,300 $ 23,000 July 5,500 $ 25,250 August 4,500 $ 23,250 September 3,000 $ 16,500 October 4,700 $ 27,000 November 6,800...
I'm supposed to solve this problem using excel but I'm not sure how to The manager...
I'm
supposed to solve this problem using excel but I'm not sure how
to
The manager of a local bakery and cafe is trying to determine how the store's monthly costs vary with the number of customers served. The manager knows that direct materials and direct labor costs tend to be higher when the bakery has more customers but is not sure about the overhead, or indirect, costs of running the business. The following table shows the number of customers...
need part 3, 4, 6, 7 help All work must be completed using this Excel spreadsheet....
need part 3, 4, 6, 7 help
All work must be completed using this Excel spreadsheet. All journal extries, financial statements, etc. must be prepared in clean, proper form. Reference your textbook and past courses for examples or templates to mod Use the current year for dating purposes. This project is valued at 120 points. The grading rubric is available on the last sheet labeled "Grading Rubric." Information on using Excel can be found in the Excel Notes section below....
**** PLEASE INCLUDE EXCEL FORMULAS ON SPREADHEET******* Kline Sisters Company operates a gift shop where peak sales and...
**** PLEASE INCLUDE EXCEL FORMULAS ON
SPREADHEET*******
Kline Sisters Company operates a gift shop where peak sales and activity occur in the months of December and January. Data regarding the store's operations follow: Sales are budgeted at $360,000 for January, 320,000 for February, and $250,000 for March and $240,000 in April. Collections are expected to be 30% in the month of sale, 65% in the month following the sale, 3% in the second month following sale and 2% uncollectible. The...
Please solve the following problem using Microsoft Excel Solver and provide screen shots of cells, formulas,...
Please solve the following problem using Microsoft Excel Solver and provide screen shots of cells, formulas, constraints, etc. Jenko and Schmidt are going to Law School! After their recent cases led to significant property damage and cost too much for the department to handle, Jump Street has been disbanded and Jenko and Schmidt have been reassigned to do undercover work for the white collar crimes division. They must now attend law school for training. Rather surprisingly, Jenko finds that years...
Preferably in excel form
Part B: Calculate using Excel formulas, the NPV of each of the 3 projects It is possible that ABC Company may not be able to advise ABC Company complete all 3 projects. Therefore, as to the order in which they should pursue the projects (i.e. which project should ABC Company attempt to do first, second, and last). Provide justification and analysis as to why you chose the order you did. The analysis must also be done...
MUST BE DONE ON EXCEL USING
EXCEL FORMULAS
2. Using the trial balances data on the following page complete the following in Excel using two worksheets (Total 345 points): a. For worksheet 1: i. Enter the data as provided (36 pts) ii. Use the SUMO function to check your data entry, (12 pts) iii. Format the columns using appropriate formats ($ signs in first and last numbers in a column; numbers line up, commas for 000's, underlining of numbers only...
PLEASE HELP! The master budget must be completed using formulas.
there must be a sales budget, production budget, Direct Materials
budget, Direct labor budget, manufacturing overhead budget, selling
and admin budget, budgeted income statement, Schedule of exp
collections, sch of exp payments, sch of exp payments DM, cash
budget, and budgeted balance sheet. please include the formulas you
used.
Purpose: The purpose of this project is to help you practice and reinforce the steps necessary to complete a Master Budget,...
I'm
supposed to solve this problem using excel but I'm not sure how
to
The manager of a local bakery and cafe is trying to determine how the store's monthly costs vary with the number of customers served. The manager knows that direct materials and direct labor costs tend to be higher when the bakery has more customers but is not sure about the overhead, or indirect, costs of running the business. The following table shows the number of customers...
need part 3, 4, 6, 7 help
All work must be completed using this Excel spreadsheet. All journal extries, financial statements, etc. must be prepared in clean, proper form. Reference your textbook and past courses for examples or templates to mod Use the current year for dating purposes. This project is valued at 120 points. The grading rubric is available on the last sheet labeled "Grading Rubric." Information on using Excel can be found in the Excel Notes section below....
**** PLEASE INCLUDE EXCEL FORMULAS ON
SPREADHEET*******
Kline Sisters Company operates a gift shop where peak sales and activity occur in the months of December and January. Data regarding the store's operations follow: Sales are budgeted at $360,000 for January, 320,000 for February, and $250,000 for March and $240,000 in April. Collections are expected to be 30% in the month of sale, 65% in the month following the sale, 3% in the second month following sale and 2% uncollectible. The...
Most questions answered within 3 hours.
-
Batteries play an important role in our everyday lives. From
making many devices mobile, to allowing...
asked 9 seconds from now -
Determine the pHpH of an HFHF solution of each of the following
concentrations. The KAKA value...
asked 3 minutes ago -
Two point charges of 7.0mL are initially 11.5m apart. What is
the change in potential energy...
asked 4 minutes ago -
It is possible to iterate through an array quickly and easily
using a loop?
asked 7 minutes ago -
Please write as a short answer
You have heartburn and a two hour working session on...
asked 8 minutes ago -
Please solve with excel and mention the excel function.
Thanks
Kevin deposits $10,000 in a savings...
asked 10 minutes ago -
Which Special Journal would the following transaction be
journalized in?
Sold merchandise on account to Customer...
asked 22 minutes ago -
Assuming 100% dissociation, calculate the freezing point (?fTf)
and boiling point (?bTb) of 1.45 ? K3PO4(aq)1.45...
asked 24 minutes ago -
An inflated helium balloon with a volume of 0.35L at
sea level (1.0 atm) was allowed...
asked 26 minutes ago -
Python 3.0 Please
Write a function that takes, as arguments, a binary string, a
list of...
asked 54 minutes ago -
(a) Calculate the momentum of a 2150 kg elephant charging a
hunter at a speed of...
asked 42 minutes ago -
all the following is an example of a fixed cost except: any cost
that changes in...
asked 44 minutes ago