Examlex

Solved

Yates Corp Required:
(A

question 45

Essay

Yates Corp. wants to develop a cost equation for its administrative costs. The controller believes the appropriate cost driver is units produced. Last year's data are presented below:
MonthUnits ProducedAdministrative Costs January 32,500$24,288 February 37,70027,720 March 24,70017,820 April 40,30030,360 May 49,40037,290 June 42,90029,040 July 53,30032,670 Alugust 45,50030,030 September 26,00020,460 October 48,10034,320 November 61,10040,920 December 54,60036,630\begin{array}{lcc}\text {Month}&\text {Units Produced}&\text {Administrative Costs}\\\text { January } & 32,500 & \$24,288 \\ \text { February } & 37,700 &27,720 \\ \text { March } & 24,700 &17,820 \\\text { April } & 40,300 &30,360 \\ \text { May } & 49,400 &37,290 \\ \text { June } & 42,900 &29,040 \\\text { July } & 53,300 &32,670 \\ \text { Alugust } & 45,500 &30,030 \\ \text { September } & 26,000 &20,460 \\\text { October } & 48,100 & 34,320\\ \text { November } & 61,100 &40,920 \\ \text { December } & 54,600 &36,630 \\\end{array}

 SUMMARY OUTPUT  Regrerrian Statirticr  Multiple R 0.96538 R Squjare 0.931965 Adjusted R-Square 0.925162 Starddard Error 1,881.23 Observations 12\begin{array}{c} { \text { SUMMARY OUTPUT } } \\ { \text { Regrerrian Statirticr } } \\\begin{array} { | l | r | } \hline \text { Multiple R } & 0.96538 \\\hline \text { R Squjare } & 0.931965 \\\hline \text { Adjusted R-Square } & 0.925162 \\\hline \text { Starddard Error } & 1,881.23 \\\hline \text { Observations } & 12 \\\hline\end{array}\end{array}
 Coefficiend  Standard  Error  t Stat  P-valke  Lower  95%  Upper 95%  Irtercept 4,919.482,221.3292.210.05115629.94859,868.909 Units  produced 0.5861540.05008211.703.69E070.4745600.697743\begin{array} { | l | r | r | r | r | r | r | } \hline & \text { Coefficiend } & \begin{array} { c } \text { Standard } \\\text { Error }\end{array} & \text { t Stat } & \text { P-valke } & \begin{array} { c } \text { Lower } \\\text { 95\% }\end{array} & \text { Upper 95\% } \\\hline \text { Irtercept } & 4,919.48 & 2,221.329 & 2.21 & 0.051156 & - 29.9485 & 9,868.909 \\\hline \begin{array} { l } \text { Units } \\\text { produced }\end{array} & 0.586154 & 0.050082 & 11.70 & 3.69 \mathrm { E } - 07 & 0.474560 & 0.697743 \\\hline\end{array}
Required:
(a.) What is the equation for administrative costs using the regression analysis?
(b.) Does the variable "units produced" have statistical significance? Explain.
(c.) Prepare an estimate of administrative costs for a month when 30,000 units are produced.


Definitions:

Uninformed Party

An individual or entity in a transaction who lacks pertinent information or knowledge that the other party may possess, leading to a potential imbalance in the transaction.

Informed Party

An individual or entity that possesses full knowledge of the pertinent facts and information related to a specific transaction or situation.

Information Asymmetry

A situation in which one party in a transaction has more or superior information compared to another party.

Worker

An individual engaged in a specific activity or labor, especially for pay.

Related Questions