Assignment 3 2024

Below is budgeted production and sales information for Flushing Company for the month of December. Product XXX Product ZZZ Estimated beginning inventory 30,300 units 17,800 units Desired ending inventory 36,400 units 14,500 units Region I, anticipated sales 334,000 units 256,000 units Region II, anticipated sales 183,000 units 147,000 units The unit selling price for product XXX is $7 and for product ZZZ is $15. Budgeted sales for the month is Oa. $10,576,000 Ob. $6,440,000 Oc. $13,800,000 Od. $9,664,000

Molly O'Malley is the new manager of the materials storeroom for Tudor Manufacturing. Mollly has been asked to estimate future monthly purchase costs for part​ #696, used in two of ​Tudor's products. Molly has purchase cost and quantity data for the past 9 months as​ follows: Month Cost of Purchase Quantity Purchased January $12,410 2,650 parts February 12,770 2,850 March 17,403 4,116 April 15,838 3,761 May 13,249 2,901 June 14,022 3,376 July 15,237 3,644 August 10,087 2,287 September 14,900 3,592 Estimated monthly purchases for this part based on expected demand of the two products for the rest of the year are as​ follows: Month Purchase Quantity Expected October 3,350 parts November 3,770 December 3,050 The computer in Molly​'s office is​ down, and Molly has been asked to immediately provide an equation to estimate the future purchase cost for part​ #696. Molly grabs a calculator and uses the​ high-low method to estimate a cost equation. What…

Cost of Direct Materials Used in Production for a Manufacturing Company Walker Manufacturing Company reported the following materials data for the month ending June 30: Materials purchased $215,500 Materials inventory, June 1 68,000 Materials inventory, June 30 56,700 Determine the cost of direct materials used in production by Walker during the month ended June 30.

The activities for Christina's Visa Card account for one billing period is shown below. The previous balance on (June 7) was $2793.14 Christina's Visa Card Activities (June 7 - July 7) Description Billing date Shopping Date Amount June 7 $2793.14 June 11 $162.55 June 16 Restaurant $123 June 19 $1500 Payment Sam's Club and gas June 22 July 4 $179.37 Entertainment $60.56 Determine the average daily balance for the next billing (July 7). Express the amount in two decimal places. For example, 23.45, or 57.20, or 89.00. The average daily balance for the next billing (July 7) is $

Background information: Allison collected additional days of data to monitor the process. Steps to monitor using the control charts: Now monitor the process. An additional ten days of data have been collected, see table labeled “1st 10 Days of Monitoring Reservation Processing Time” in the Data File. Develop Xbar and R charts for the 1st 10 days of monitoring. Plot the data for the 1st 10 days on the Xbar and R charts. Is the process in control? If the control chart indicates an out-of-control process, note which days, the pattern, and whether it is the Xbar or R chart.   Now that we have set up the control charts using enough data from a stable process, the 30 days of data, we will monitor the process. While monitoring the process, what will we use as the upper control limit for the R (range) Chart to compare against our new range values? Enter your response to three decimal places. You do not need to include the units (minutes), ONLY the numeric value. USE EXCELL DATA TO GET…

Month Number of Tables Produced EA 10. LO 2.3 This cost data from Hickory Furniture is for the year 2017. Factory Utility Expenses January 550 $2,063 February 710 2,663 March 650 2,438 April 470 1,823 May 512 1,920 June 625 2,344 July 805 3,019 August 750 2,813 September 675 2,531 October 525 1,969 November 875 3,281 December 685 2,569 A. Using the high-low method, express the company's utility costs as an equation where X represents number of tables produced. B. Predict the utility costs if 800 tables are produced. C. Predict the utility costs if 600 tables are produced. D. Using Excel, create a scatter graph of the cost data and explain the relationship between number of tables produced and utility expenses.

Development of Version 2.0 of a particular accounting software product is being considered by Jose Noguera's technology firm in Baton Rouge. The activities necessary for the completion of this project are listed in the following table: Normal Crash Activity Time (weeks) Time (weeks) A B C D E F G 4 2 3 8 6 3 4 3 1 3 4 3 2 2 a) Based on the given information regarding the activities for the project, the project length = Normal Cost $2,000 $2,100 $500 $2,300 $800 $3,200 $1,500 weeks. Total Cost with Crashing Immediate Predecessor(s). $2,650 $2,900 $500 $2,600 $1,100 $4,600 $2,100 A B C D, E

Identify several types of manufacturing companies for which process costing would be an appropriate product-costing system. What characteristics do the products of these companies have that would make process costing a good choice? How is process costing similar and different in a second or later processing department?

Different LIFO inventory assumptions: Beginning inventory of 10 units @ $15 = $150 Purchases month #1 of 10 units @ $15 = $150 Purchases month #2 of 10 units @ $10 = $100 Cost of goods available for sale (subtotal) = $400 Less ending inventory of 10 units Equals cost of goods sold (also known as cost of sales) Under the LIFO inventory method, what is the cost of goods sold amount?

The following data represent the inventory figures for 55-gallon fish tanks at an aquarium.   *Chart Attached*    (A): How many fish tanks did the aquarium have available for sale? __________________fish tanks   (B): Calculate the total cost (in $) of the tanks available for sale. $____________   (C): If physical inventory on December 31 showed 88 tanks on hand, calculate their dollar value by using FIFO. $____________

Jensen Tire & Auto is in the process of deciding whether to purchase a maintenance contract for its new computer wheel alignment and balancing machine. Managers feel that maintenance expense should be related to usage, and they collected the following information on weekly usage (hours) and annual maintenance expense (in hundreds of dollars). Weekly Usage(hours) AnnualMaintenanceExpense 13 17.0 10 22.0 20 30.0 28 37.0 32 47.0 17 30.5 24 32.5 31 39.0 40 51.5 38 40.0 test statistic is 6.90 Find the p-value. (Round your answer to three decimal places.) p-value =  State your conclusion. Reject H0. We conclude that the relationship between weekly usage (hours) and annual maintenance expense (in hundreds of dollars) is significant. Do not reject H0. We conclude that the relationship between weekly usage (hours) and annual maintenance expense (in hundreds of dollars) is significant.      Reject H0. We cannot conclude that the relationship between weekly usage…

Please answer ASAP. Thank you!

Alert for not submit AI generated answer. I need unique and correct answer. Don't try to copy from anywhere. Do not give answer in image formet and hand writing

George Galoz & Freres, located in Grenchen, Switzerland, makes luxury custom watches in small lots. One of the company's products, a platinum diving watch, goes through an etching process. The company has recorded etching costs as follows over the last six weeks: Week 1 Units (7 2 30 Total Etching Cost 5 18 17. 25 20 24 16 $ 120 For planning purposes, management would like to know the variable etching cost per unit and the total fixed etching cost per week. 3. If the company processes five units next week, what would be the expected total etching cost? (Round your intermediate calculations and final answer to 2 decimal places) Expoctea lotal aiching cost Answer is complete but not entirely correct. 20 50

Marcia Baker is the new manager of the materials storeroom for Keller Manufacturing. Marcia has been asked to estimate future monthly purchase costs for part​ #696, used in two of Keller​'s products. Marciahas purchase cost and quantity data for the past 9 months as​ follows: Month     Cost of Purchase    Quantity Purchased January       $12,410.                       2,730 parts February.      12,880                        2,880 March           17,505                         4,148 April              15,869                         3,761 May               13,170                         2,912 June              13,867                         3,332 July               15,237                          3,644 August          10,061                          2,287 September     14,960                        3,582   Estimated monthly purchases for this part based on expected demand of the two products for the rest of the year are as​ follows: Month Purchase Quantity Expected October…

Please answer C. and D. Palisades Eco-Park is a small ecological reserve that admits a relatively small number of visitors on any day, but provides both educational and entertaining lectures, exhibitions, and opportunities to observe nature. The company has collected the following data on labor costs and number of visitors to the park over the last 30 months.   Month Labor Cost Visitors 1 $ 25,820 1,700 2 $ 36,290 2,592 3 $ 39,968 2,811 4 $ 31,648 2,222 5 $ 34,809 2,373 6 $ 32,672 2,181 7 $ 32,023 2,205 8 $ 38,334 2,676 9 $ 38,568 2,760 10 $ 46,933 3,572 11 $ 42,157 2,976 12 $ 39,030 2,804 13 $ 34,444 2,415 14 $ 33,173 2,336 15 $ 36,971 2,508 16 $ 26,500 2,099 17 $ 30,663 3,397 18 $ 29,961 2,786 19 $ 27,590 2,412 20 $ 30,003 2,972 21 $ 25,692 2,000 22 $ 24,655 1,794 23 $ 28,892 3,267 24 $ 30,153 3,817 25 $ 28,119 2,592 26 $ 31,690 3,274 27 $ 28,651 2,989 28 $ 29,927 3,050 29 $ 28,438 2,511 30 $ 27,874 2,075…

What is the multifactor productivity ratio for week 1?  What is the multifactor productivity ratio for week 2?  What is the multifactor productivity ratio for week 3? Use two decimal places.

How can I calculate part B using excel?

3

Determine if the type of data for each variable is: Quantitative Discrete data, Quantitative Continuous data, or Qualitative data Customer      Type of loan       Account number.     Interest Rate   Payment left Mark Johnson    car                   56122                            2.5%        8 Kam Nelson     Mortgage          12234                           4.2%      10 Fatima Jackson    personal       23451                          6%         5 Allen Rod            car                         11111                           3.1%        7

The Lawson Fabric Mill Produces five different fabrics. Each fabric can be woven on one or more of the mill’s 36 looms. The sales department’s forecast of demand for the next month is shown in below Table 1, along with data on the selling price per yard, variable cost per yard, and purchase price per yard. The mill operates 24 hours a day and is scheduled for 30 days during the coming month. The mill has two types of looms: draw and regular. The draw looms are more versatile and can be used for all five fabrics. The regular looms can produce only three of the fabrics. The mill has a total of 36 looms: 8 are draw and 28 are regular. The rate of production for each fabric on each type of loom is given in below Table 2. The time required to change over from producing one fabric to another is negligible and does not have to be considered.   The Lawson Fabric Mill satisfies all demand with either its own fabric or fabric purchased from another mill. Fabrics that cannot be woven at the…

The data below have been taken from the cost records of the Halifax General Hospital. The data relate to the costs of admitting patients at various levels of patient activity: Month                                                      Number of Patients                     Admitting                                                                                 Admitted                    Department CostsMay.....................................................................     3,600                                  $ 29,400June ....................................................................   3,800                                   $ 28,700July ......................................................................   2,900                                  $ 27,400August ................................................................   3,200                                   $ 28,000September ..........................................................   3,300…

The sales manager of a large automotive parts distributor wants to estimate the total annual sales for each of the company’s regions.  Three factors appear to be related to regional sales: the number of retail outlets in the region, the total personal income of the region, and the number of cars registered in the region. The following table shows the data for 10 regions that were gathered for last year sales.    The excel data file for this problem is:final exam question 6B spring 2021.xlsx     Region Annual sales  ($ million) Number of retail outlets Number of automobiles registered (million) Personal income ($ billion) 1 37.702 1,739 9.27 85.4 2 24.196 1,221 5.86 60.7 3 32.055 1,846 8.81 68.1 4 3.611 120 4.81 20.1 5 17.625 1,096 10.31 33.8 6 45.919 2,290 11.62 95.1 7 29.600 1,687 8.96 69.3 8 8.114 241 6.28 16.5 9 20.116 649 7.77 34.9 10 12.994 1,427 10.92…