36.8k views
0 votes
Crane Company provides this information for the month ended October 31, 2025: Sales on credit $305,600. On the break-even analysis worksheet, enter the correct formula to calculate the gross revenue in cell D7.

a. =B7-C7
b. =B7/D7
c. =B7*(1+D7)
d. =B7+C7

User Wpp
by
7.4k points

1 Answer

1 vote

Final answer:

To calculate gross revenue for the Crane Company using a break-even analysis worksheet, the correct formula to input in cell D7 is 'd. =B7+C7', which sums up the base amount in cell B7 and any additional amounts in cell C7.

Step-by-step explanation:

The student has asked how to calculate the gross revenue for the Crane Company as of October 31, 2025, given their sales on credit. To find the correct formula to input in cell D7 on the break-even analysis worksheet, one must consider the options provided.

In accounting and financial analysis, gross revenue typically refers to the total sales on credit and does not need adjustments for costs or expenses. Therefore, the correct answer is d. =B7+C7.

This choice implies that to get the gross revenue, you start with a base amount in cell B7 and add any additional amounts recorded in cell C7. Given that sales on credit are gross revenues, they should be taken as the total without any deductions yet, meaning we simply want to sum any numbers that reflect on the sales made.

User Tharaka Nuwan
by
7.6k points