which of the following procedures is generally performed in all audits because of the unusual risks related to the items recorded? multiple choice review of general journal entries. review of cash disbursements. review of cash receipts. review routine sales transactions.
Answers
The procedure generally performed in all audits due to unusual risks related to the items recorded is the review of cash disbursements.
The evaluation of cash disbursements is a practice that is often carried out in every audit because of the unusual risks associated with the items documented. This is because cash payments are more prone to fraud and financial misappropriation, particularly in the presence of lax internal controls or a lack of monitoring.
Auditors can examine cash disbursements to check the authenticity and correctness of transactions, ensure adherence to rules and regulations, and find any discrepancies or mistakes in the recording of financial data. Even though other processes like checking cash receipts, standard sales transactions, and general journal entries are crucial, they might not carry the same level of risk as cash disbursements.
Learn more about cash disbursements:
https://brainly.com/question/30163484
#SPJ4
Related Questions
what is marketing
please answer if u know,i will mark brainiest
Answers
Answer:
Marketing refers to activities a company undertakes to promote the buying or selling of a product or service. Marketing includes advertising, selling, and delivering products to consumers or other businesses. Some marketing is done by affiliates on behalf of a company.
hope it helps!
Suppose a lite insurance company selis a $200,000 1-year lecms iffe insurance policy to a 20yoat-old female for $230. According to the Nabional Vial Statistics Report. 58(21) the probablity that the female survives the year is 0999544 Compute and interpret the expected value of this pollcy to the insurance company The expected valje is s (Round to the nearest cent as needed) Which of the folowing interpretations of the expected valise is correct? Select the correct choice below and fir in the answer box to complete your choice (Round to the nearest cent as needed) A. The insurance company expects to make a maximum profit of 5 on every 20 -year-old fermale it insures for 1 year. B. The insurance company expects to make a profit of : on every 20-year-old female it insures for 1 month C. The irsurance company expecis to make a minimum proft of A on every 20 -year-old female it insures for 1 month D. The insurance compary empecta ta make a profit of 3 on every 20 -yeat-old female it inscires for 1 year
Answers
The expected value of this policy to the insurance company is $229.95. The correct interpretation of the expected value is "The insurance company expects to make a minimum profit of $229.95 on every 20-year-old female it insures for 1 year." Therefore, the correct option is C.
Expected value of this policy to the insurance company can be computed as follows:
Expected Value = (Probability of Survival * Amount Paid by the Policy Holder) - (Probability of Death * Amount Paid to the Policy Holder)
Probability of survival is given as 0.999544 and hence the probability of death is 1 - 0.999544 = 0.000456
Amount paid by the policyholder is given as $230 and amount paid to the policyholder in case of death is $200,000
Expected Value = (0.999544 * $230) - (0.000456 * $200,000)
Expected Value = $229.95
The expected value of this policy to the insurance company is $229.95. The correct interpretation of the expected value is "The insurance company expects to make a minimum profit of $229.95 on every 20-year-old female it insures for 1 year." Therefore, the correct option is C.
To know more about insurance company, visit:
https://brainly.com/question/28548561
#SPJ11
(6)
An open economy is facing an increasing budget deficit together with a high rate of unemployment.
Discuss, with reference to the IS-LM model, the policy mix that this economy can apply to reduce both the deficit and the rate of unemployment.
Answers
In an open economy facing an increasing budget deficit and high unemployment, the IS-LM model can provide insights into the policy mix that can be applied to address both issues. Here's a discussion on the potential policy mix:
1) Expansionary Fiscal Policy: The government can employ expansionary fiscal policy to stimulate the economy and reduce unemployment. By increasing government spending or reducing taxes, aggregate demand (AD) can be boosted, leading to increased output and employment. The increase in AD shifts the IS curve to the right, helping to reduce unemployment. However, expansionary fiscal policy may exacerbate the budget deficit unless accompanied by measures to increase revenue or control spending.
2) Monetary Policy: The central bank can implement expansionary monetary policy to support economic growth and reduce unemployment. By lowering interest rates, the cost of borrowing decreases, encouraging businesses and individuals to increase investment and consumption. The lower interest rates also lead to a decrease in the demand for the domestic currency, which weakens the exchange rate, making exports more competitive. This shift in the LM curve helps to stimulate economic activity and reduce unemployment.
3) Structural Reforms: In addition to fiscal and monetary policies, structural reforms can play a crucial role in addressing unemployment in the long term. These reforms can focus on improving labor market flexibility, promoting skill development and education, and encouraging entrepreneurship. By removing barriers to employment and enhancing productivity, structural reforms can help to increase job opportunities and reduce long-term unemployment.
It's important to note that the policy mix should consider the specific circumstances and challenges of the open economy. The effectiveness of these policies depends on factors such as the level of international trade, capital mobility, exchange rate regime, and credibility of the government's actions.
In summary, a combination of expansionary fiscal policy, expansionary monetary policy, and structural reforms can be employed to reduce the budget deficit and lower unemployment. The policy mix aims to stimulate aggregate demand, increase investment, and improve labor market conditions to achieve a more sustainable and balanced economy.
To learn more about policy
https://brainly.com/question/28424760
#SPJ11
FOOD;
1.how to reduced food?
2.how to reused food?
3.how to recycled food?
WATER;
1.how to reduced water?
2.how to reused water?
3.how to recycled water?
please
Answers
ending inventory is made up of the oldest purchases when a company uses group of answer choices first-in, first-out last-in, first-out average cost retail method
Answers
The method of accounting for inventories in which the first goods acquired are the first goods sold, and the most recent goods acquired are in the ending inventory, is called the first-in, first-out (FIFO) method.
The ending inventory is made up of the newest purchases when a company uses the last-in, first-out (LIFO) method of inventory accounting.LIFO and FIFO are two inventory costing systems that are commonly used in the accounting field. The LIFO method, also known as the last-in, first-out method, is used to compute the value of a company's inventory on a balance sheet. This method assumes that the most recently purchased items in inventory are sold first.
As a result, the cost of products sold is determined by taking the cost of the newest inventory items and working backwards until the cost of all goods sold has been accounted for.In comparison, FIFO is a method that uses the opposite approach to inventory accounting.
The first-in, first-out (FIFO) approach, like LIFO, assumes that the oldest items in inventory are sold first. Because the cost of the oldest inventory items are accounted for first under FIFO, this method is frequently used to compute the cost of goods sold (COGS).
Average cost and the retail method are two other inventory costing techniques that businesses can use to determine the value of their inventory.
For more such questions goods,Click on
https://brainly.com/question/25262030
#SPJ8
Jordynne was the manager of Pets-R-Us, a pet store in Southern Valley Mall. Pets-R-Us had a one-year lease, and rent payments were $2,000.00 per month. Five months into the lease, Jordynne found a better site for the pet store. She notified Southern’s manager, vacated the mall, and moved her store to its new location. After two months, Southern was able to re-lease the premises to another retail store, but at a reduced rent of $1,800.00 per month. If Southern successfully sues Pets-R-Us, Southern will likely receive:_________
Answers
Southern is likely to receive $14,000 for damages
A lease such as the one between Jordynne and Southern represents a contract. Due to this, it is expected both parties met the conditions previously agreed. This means:
Jordynne should have stayed in the first site for a year.Southern cannot ask Jordynne to leave the site she rented.In this context, it was Jordynne the one that breached the contract, as a consequence Southern can sue her. In this case, it is expected Jordynne has to pay the rent for the months she was not in Southern Vally Mall.
$2,000 x 7 months (she left in the fifth month) = $14,000
Learn more in: https://brainly.com/question/25311936
for which person would renting a home be a better option than getting a mortgage?
Answers
Answer:
Someone who wants ro avoid spending time and money on maintenace
Explanation:
Job seekers often spend a large amount of time writing their résumés and neglect to write quality cover letters. Please select the best answer from the choices provided
T or F
Answers
Answer:
TRUE............................................................
Explanation:
Job seekers often spend a large amount of time writing their resumes and neglect to write quality cover letters. Thus, the given statement is true.
What is a resume?A curriculum vitae, often known as a resume or CV, is a document that a person creates and uses to highlight their educational history, professional experience, and accomplishments. Although there are many uses for resumes, they are most frequently employed to find new jobs. A standard resume includes a "summary" of relevant educational background and work history.
The resume is normally one of the first things a potential employer sees about a job seeker, along with a cover letter and occasionally an application for employment, and is commonly used to screen applicants, frequently followed by an interview. The curriculum vitae utilized for employment in the UK (and other European nations) is more comparable to the resume —a condensed, overview of one's educational background.
Learn more about your resume, here:
https://brainly.com/question/862477
#SPJ2
evaluate three ways in which employment will minimize emotional stress
Answers
Answer:
Workplace is a different environment. If you are stress by your home then being in a workplace can help you stay away from the source of stress.
Your workmates is a potential source of happiness.
Being paid by the task that you have done.
Explanation:
The ways employment will minimise emotional stress are:
Employment provides a source of income with which employees can afford to buy items that would make them happy. As a result of employment, people are able to socialise with other workers. This would prevent isolation and reduce emotional stress. As a result of employment, people becomes less bored and more productive. This can eliminate emotional stress.What is employment?Employment is when labour has a job that they earn an income from. Working as a teacher is a form of employment.
Employment is a source of income, friendship and an avenue for socialisation. These can minimise emotional stress.
To learn more about employment, please check: brainly.com/question/10940465
which of the following is not a particularly sound or valid reason why deliberate pursuit of unethical strategies and tolerance of unethical conduct is a risky practice?
Answers
Of the following reasons, the one that is not particularly sound or valid for why the deliberate pursuit of unethical strategies and tolerance of unethical conduct is a risky practice is: The belief that being unethical can always lead to long-term success.
The pursuit of unethical strategies and tolerance of unethical conduct can lead to severe consequences such as loss of reputation, legal actions, and financial penalties. However, there is no valid reason to intentionally pursue unethical strategies or tolerate unethical conduct as it can also lead to a decrease in employee morale, customer loyalty, and overall company culture. In the long run, it is not a sustainable or successful business practice and can ultimately harm the company's success.
The reason this statement is not sound or valid is that while some companies may experience short-term success with unethical practices, it is not a sustainable strategy in the long run. Unethical conduct can lead to negative consequences such as legal issues, reputational damage, and loss of trust from customers and stakeholders.
To know more about unethical strategies, visit:
https://brainly.com/question/29560618
#SPJ11
President Biden holding a press conference on gun-control measures in order to use constituents to put pressure on Congress, is an example of a President's Informal power of a. Going Public b. Persuasion c. Commander-in-Chief d. Issuing executive orders
Answers
President Biden holding a press conference on gun-control measures in order to use constituents to put pressure on Congress is an example of a President's informal power of "Going Public."
Going Public is a strategy used by presidents to directly communicate with the public and mobilize public opinion in order to influence policymaking and put pressure on Congress to act on a particular issue. By holding a press conference and discussing gun-control measures, President Biden is using the power of public persuasion to rally support from constituents and create public pressure on Congress to pass gun-control legislation. This informal power allows the President to bypass traditional channels and appeal directly to the public, thereby influencing the political environment and potentially shaping the legislative agenda.
To know more about Biden click the link below:
brainly.com/question/28996929
#SPJ11
When should a person proceed with a
choice in terms of marginal benefits
and cost?
O when the market is high
O when there is no difference
O when the benefits outweigh the
cost
Answers
Answer:
when the difference outweighs the cost
How does inflation affect starndard of?
Answers
Answer:
Inflation affects your standard of living because it can reduce your spending power. ... Wage earners experience the same problem if wages stay flat or if inflation outpaces wage increases. You avoid the ravages of inflation if your income level rises at a pace that exceeds the rate of inflation
Explanation:
the key reasons that an organization should adopt planning and strategic management are to:
Answers
Let understand that Strategic planning is the approach used to for process of documenting and establishing the direction of the organisation goals and objectives.
Strategic planning creates an organization vision, mission and priorities etc
Let understand that "Strategic management" refers to the overall process of strategic planning to implementation and executing of other plan.
The key reason for adopting these plan are:
Gives direction and momentum: The plans gives an organization direction on how to operate.Encouragement of new ideas: The plans helps to encourage new ideas because the business new to expand.Its gives Sustainable competitive advantage.Learn more about this here
brainly.com/question/4564918
is 1 a prime number
tell me pls im to dumm
Answers
Answer:
No
Explanation:
All prime numbers most be more then 1.
A network security device that monitors incoming and outgoing network traffic and decides whether to allow or block specific traffic based on a defined set of security rules.
Answers
Answer:
Firewall.
Explanation:
Firewall can be defined as a network security device that monitors incoming and outgoing network traffic and decides whether to allow or block specific traffic based on a defined set of security rules.
Simply stated, a firewall is a network security protocol that monitors and controls inbound and outbound traffic based on set aside security rules.
A firewall is used to control access to a computer or network, as it creates a barrier between a computer or a network and the internet in order to protect against unauthorized access.
Basically, it is a network security device or security system pre-installed on most computers to essentially inspect data being transmitted to or from a computer.
Hence, firewalls are typically bidirectional, it checks all sent and received data and only allow authorized traffic through.
Answer:
Firewall.
Explanation:
Hope this helps
Quality assurance is an internal company concern &
process.
Existing (vs start up) companies often have to
transition from one method of controlling
processes to another, so they commit to a PHILO
Answers
Quality assurance is a crucial aspect of the internal company concern and the process. It is imperative that existing companies, particularly those transitioning from one method of controlling processes to another, commit to a PHILO. In this case, PHILO stands for Process, Habits, Infrastructure, Leadership, and Objectives.
PHILO can help a company to maintain its existing quality assurance processes while preparing for the transition to a new method of controlling processes. It is crucial for companies to commit to the PHILO because it sets the foundation for a successful transition. The Process component of PHILO provides an outline of the company’s current processes, and it also assists in identifying any gaps that need to be addressed.
The Habits component provides an overview of the current behaviors of the workforce, which can help identify where training is needed or where changes are required. The Infrastructure component of PHILO looks at the physical systems in place and how they can be optimized for the new method of controlling processes.
The Leadership component of PHILO helps identify the company’s leadership structure and how it can be optimized for the new method of controlling processes. Finally, the Objectives component of PHILO provides the goals and objectives for the transition, which can help keep everyone on the same page and working towards a common goal.In conclusion, the transition from one method of controlling processes to another can be challenging, but it is critical for the success of the company.
To know more about assurance visit:
https://brainly.com/question/17160521
#SPJ11
Kali wants to start her own investment firm from scratch, so she's very focused on understanding the possible drawbacks of taking this
approach. Which item belongs on Kali's list of drawbacks?
O A. withstanding the effects of a macro-level trend
ОВ. not growing quickly enough to tap into adjacent markets
OC. potentially running out of operating funds
OD paying monthly licensing and marketing fees
Answers
Answer:
C
Explanation:
because she likes to come up with advertisements which is a part of marketing
Question 1 of 10
Why do managers care about soft skills when hiring for a technical job?
A. They want to know that the applicant will enjoy corporate events
and activities.
B. They want to be sure the applicant will be able to complete the
assigned tasks.
C. They want to be sure the applicant has no outside interests that
will interfere with work.
D. They want to be sure the applicant can collaborate and work well
with other team members.
Answers
D. They want to be sure the applicant can collaborate and work well
with other team members.
Explanation:
Managers do care about soft skills when hiring for a technical job as they want to be sure the applicant can collaborate and work well with other team members. The correct option is d.
What is a technical job?Technical jobs are those that require specific talents and expertise an individual possesses that help them perform a certain task or job. These skills differ from soft skills, which instead describe character and personality traits.
Technical skills are abilities an individual acquires through practice and learning, although a person may bring an inherent propensity for a certain skill. An individual who possesses a particular proficiency for coding, for instance, would have a sought-after technical skill as a job candidate at a software or technology company. Technical job skills are ideal to list on the skill section of a resume because they shine a light on abilities and strengths.
However, it is important to realize not all technical skills at an individual’s disposal should be listed.
Learn more about technical, here:
https://brainly.com/question/3123459
#SPJ2
which of the following statements are true? multiple select question. a current asset is expected to be converted to cash or consumed within one year or an operating cycle, whichever is shorter. most businesses provide information about their bill-paying ability by classifying their assets and liabilities according to liquidity. long-term assets are usually presented before short-term assets on a classified balance sheet. the more quickly an asset is converted to cash or consumed, the more liquid it is considered.
Answers
Most businesses provide information about their bill-paying ability by classifying their assets and liabilities according to liquidity. The more quickly an asset is converted to cash or consumed, the more liquid it is considered.
How does liquidity work?A financial asset's liquidity refers to how simple it is to convert it into cash without suffering a significant loss in value. Liquidity can assist you in converting assets into useful income if you don't have enough cash on hand to cover expenses.
In investing, what does liquidity mean?In a secondary market, liquidity generally refers to how fast or easily a security can be acquired or sold. When cash is needed, liquid investments can be easily sold without incurring a large cost.
To learn more about Liquidity visit:
https://brainly.com/question/28239913
#SPJ4
If you are late paying your bill, what is the impact on your annual fee?
Answers
Answer:
It will most likely increase
Explanation:
The impact of late paying the bill is that the bill payment would likely to increase with the amount of interest.
What is bill?A bill is defined as an invoice that is received from a supplier that specifies the amount due by the recipient. For trade payables, this is the primary source document.
If the recipient is not paid the amount of the bill or paid the bill after4 the expiration of due date of the bill, then the amount of bill increased from the date of bill up to the payment.
Therefore, the late payment of bill would increase the amount of interest.
Learn more about the bill, refer to:
https://brainly.com/question/14033097
#SPJ2
will give 41 points
C. now that company Z has a list of options for improvements, how can they use step three and four of the decision making process to solve some of their problems
D. The final step of the decision making process is very important what does this step offer for company z once they have made decisions and implemented them?
Answers
Steps 3 and 4 of the decision-making process allow the company Z to evaluate the best possible alternative based on the company's available resources. Also, step 6 allows you to evaluate that decision and learn from it.
What is the decision making process?The decision-making process is a set of actions that a company can take to improve some of its activities. Generally, the decision-making process is made up of the following 6 steps:
Identify the problem.Review the objective.Identify available resources.Identify possible alternatives.Make the most convenient decision.Execute, evaluate and learn.According to the above, steps 3 and 4, allow the company to identify the resources available to solve a problem and identify the alternatives to solve that problem with the available resources.
Additionally, step 6 allows you to implement the decision that they made and constantly improve by reviewing the results of that decision.
Note: This question is incomplete because there is some information missing. However, I can answer it based on my prior knowledge.
Learn more about decisions in: https://brainly.com/question/7383200
Answer:
The first one is right... I got it right because of the first answer... thank you!
Explanation:
The Food and Drug Administration sets standards for
O advertising.
O product labeling.
O the environment.
O traffic safety.
Answers
Answer:
B. Product Labeling
Explanation:
From quizlet
The Food and Drug Administration sets standards for product labeling.
What is product labeling?Product labeling is the details information of what a products entails and this is often writing on the product.
Product labeling is an important standards set by Food and Drug Administration as this help the consumer to be know the following:
The product ingredientHow healthy or unhealthy the product are etcInconclusion the Food and Drug Administration sets standards for product labeling.
Learn more about product labeling here:https://brainly.com/question/6049878
All of these are fields that you can use to review alumni skills, the company where they work, and career fields that they work in (what they do)
Answers
There are several fields that can be used to review alumni skills, the companies where they work, and the career fields they work in.
One common field is LinkedIn, which allows users to create a professional profile and showcase their skills, work experience, and education. Employers can use LinkedIn to search for potential candidates and review their profiles to see if they have the necessary skills and qualifications for a job.
Another field is alumni associations, which can provide information on the career paths of former students. Alumni associations often maintain databases of alumni and their professional achievements, which can be used to track the career paths of graduates and identify successful professionals in various fields.
Online job boards and career websites can also be used to review alumni skills and career fields. These sites allow users to search for jobs based on specific skills, experience, and qualifications and can provide information on the companies that are hiring and the types of positions that are available.
Overall, there are many different fields that can be used to review alumni skills and career fields, and it is important to use a variety of sources to get a comprehensive understanding of the career paths of former students. By leveraging these resources, employers and alumni associations can help to connect graduates with job opportunities and support their ongoing professional development.
Learn more about alumni skills:
brainly.com/question/13446203
#SPJ11
Popularity increases a product’s
A. price
B. utility
C. life cycle
D. trial period
Answers
Answer:
life cycle
Explanation:
When a product has been popularized with adverts, people will know d product and will wanna try it out.Once this happens,the product will still be in existence prolonging the life cycle
Explain how the U.S. economic system differs from the economic system in Cuba.
Answers
what dollar amount of loans have lending tree and prosper (p2p) disbursed so far?
Answers
The dollar amount of loans, lending tree, and prosper (p2p) has done in disbursement so far is 3.4 trillion dollars
What is a lending tree?Generally, LendingTree is a digital marketplace for loans with its headquarters in Charlotte, North Carolina.
The commercial platform gives prospective borrowers the ability to connect with multiple loan operators in order to locate the most advantageous terms for various types of loans, credit cards, deposit accounts, and insurance policies.
In conclusion, They have provided loans for a total of 3.4 quadrillion dollars up to this point. They have provided loans for a total of 3,4 trillion dollars up to this point.
Read more about lending tree
https://brainly.com/question/16160901
#SPJ1
An Aribraska resident who earns $32,000 would owe how much in taxes?.
Answers
An Aribraska resident who earns $32,000 would owe $1,300 in taxes.
Data and Calculations:Resident's annual earnings = $32,000
Tax Rates:Residents pay 3% on the first $15,000 of income.
The next $25,000 earned is taxed at a rate of 5%.
Any money earned above $40,000 is taxed at 7%.
The resident will pay $1,300 ($15,000 x 3% + $17,000 x 5%) in annual tax.
Thus, an Aribraska resident who earns $32,000 would owe $1,300 in taxes.
Learn more about tax liability https://brainly.com/question/15521349
Answer:
A
Explanation:
Happy Trails, Inc. manufactures railway coaches and uses the FIFO method of process costing to record costs. The WorkminusinminusProcess Inventory of the Heating Department on October 1 was 73% complete for materials and 23% complete for conversion costs. On October 31, its ending WorkminusinminusProcess Inventory was 80% complete for materials and 43% complete for conversion costs. This means that for the ending inventory, ________% of the materials and ________% of the conversion costs were added during October.
Answers
Answer:
80 % of materials ; 43 % of conversion costs
Explanation:
The FIFO method traces equivalent units for materials and conversion costs for the following categories :
Opening Work in Process unitsUnits started and completedEnding Work in Process unitsSo the units not completed from last months are the first to be completed during the month (hence To finish Opening Work in Process). During the year there are units started and completed (hence Units Started and Completed) and units started that never gets completed (hence Ending Work in Process units).
All these physical units need to be expressed to the percentage of work done on them - equivalent units.
The question is focusing on Number 3 - Ending Work in Process units. So 80 % of materials and 43 % of conversion costs were added during October for these units.
Exp19_Excel_Ch06_ML1_Housing_Cost Project Description: Your friends, Elijah and Valerie Foglesong, want to build their dream house. They identified tentative costs, but they cannot afford the $414,717 estimated cost. You will use Goal Seek to determine an estimate of the total finished square footage they can afford. To help provide more flexibility in their decision-making, you will create a data table listing various finished square footages and their effects on the base house cost and total cost. Finally, you will create another data table showing combinations of square footages and lot prices to identify total costs. Steps to Perform: Step Instructions Points Possible 1 Start Excel. Download and open the file named Exp19_Excel_Ch06_ML1_HW-Housing Cost. Xlsx. Grader has automatically added your last name to the beginning of the filename. 0 2 Assign the range names B9 (Base), B15 (Interior), B21 (Exterior), B23 (Lot). 4 3 Enter a formula in cell B25 to calculate the total estimated cost. The total estimated cost is the sum of the base house price (B9), total interior upgrades (B15), total exterior upgrades (B21), and lot fee (B23). Be sure to use range names in the formula. 5 4 Use Goal Seek to determine the total finished square footage to meet the total cost goal of $350,000. 7 5 Enter a series of total square footage ranging from 1,800 to 3,600 in increments of 200 in the range D6:D15. Apply Blue font and Comma Style with zero decimal places to the series. 12 6 Enter a reference to the base house price in cell E5 and a reference to the total estimated cost in cell F5. 7 7 Complete the single variable data table in the range D5:F15. Be sure to use total square footage as the column input. Apply Custom number formats to give appropriate descriptions to the second and third columns. Apply these formats to the headings: bold, center, and Blue font color. 12 8 Identify the square footage, base price, and total cost in the data table that comes closest to their goal. Apply Yellow fill color to those cells. 6 9 Copy the square footage substitution values, range D6:D15 to the range H6:H15 and remove the fill color. Enter these lot price substitution values in the range I5:K5: 90000, 96000, and 102675. Format these values with Accounting Number Format with zero decimal places and Blue font color. 12 10 Enter the reference to the total estimated cost in the appropriate location for the second data table. Apply a custom number format to display Total Sq Ft in that cell. Apply Blue font and bold to that cell. 9 11 Complete the two-variable data table using total square footage as the Column Input and lot price as the Row Input. Apply a Custom number format to the reference to the formula cell. Apply Yellow fill color to the total price in each column that comes closest to their goal. 8 12 Format results in both tables with Accounting Number Format with zero decimal places. 4 13 Create a scenario named Ideal Costs, using Base price per square foot and Lot fee (use cell references). Enter these values for the scenario: 80, 102,675. 3 14 Create a scenario named Increased Costs, using Base price per square foot and Lot fee (use cell references). Enter these values for the scenario: 100, 110,000. 3 15 Create a scenario named Low Costs, using Base price per square foot and Lot fee (use cell references). Enter these values for the scenario: 60, 80,000. 3 16 Generate a scenario summary report using the cell references for Price per square foot and Lot Fee. Add the appropriate formatting to the newly created report 5 17 Save and close Exp19_Excel_Ch06_ML1_HW-Housing Cost. Xlsx. Exit Excel. Submit the file as directed. 0 Total Points 100
Answers
Your friend Elijah and Valerie Foglesong should be able to use the information you provide to make informed decisions about the size and cost of their dream house.
To complete this project, you need to follow the steps below:
Open the Excel file named Exp19_Excel_Ch06_ML1_HW-Housing Cost in Excel and save it in your computer.
In cell B9, assign the range name "Base" to represent the base house price. In cell B15, assign the range name "Interior" to represent the total cost of interior upgrades. In cell B21, assign the range name "Exterior" to represent the total cost of exterior upgrades. In cell B23, assign the range name "Lot" to represent the lot fee.
In cell B25, use the formula "=B9+B15+B21+B23" to calculate the total estimated cost of the house. Make sure to use range names in the formula.
Use Goal Seek to determine the total finished square footage that meets the total cost goal of $350,000. You can find Goal Seek under the "Data" tab in Excel.
In cells D6 to D15, enter a series of total square footage ranging from 1,800 to 3,600 in increments of 200. Apply Blue font and Comma Style with zero decimal places to the series. Use range names in the formula.
In cells E5 and F5, enter the base house price and total estimated cost, respectively.
Complete the single variable data table in the range D5:F15 by using total square footage as the column input. Apply Custom number formats to give appropriate descriptions to the second and third columns. Apply these formats to the headings: bold, center, and Blue font color.
Identify the square footage, base price, and total cost in the data table that comes closest to their goal. Apply Yellow fill color to those cells.
Total Points: 60
Feedback:
Step 1: 10 points
Step 2: 10 points
Step 3: 10 points
Step 4: 10 points
Step 5: 10 points
Step 6: 10 points
Step 7: 10 points
Step 8: 10 points
Learn more about decisions visit: brainly.com/question/27004710
#SPJ4